I’d forgotten this when writing a stored procedure to provide access to log entries in a database table.  This older post describes the problem, and two options for fixing it.  I chose the version that uses the DATEADD() function call for my stored procedure.