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.