Return to Snippet

Revision: 8940
at October 14, 2008 15:57 by hoffstein


Initial Code
DATEADD(s, -1, DATEADD(d, 1, DATEADD(d, DATEDIFF(d, 0, @date), 0)))

Initial URL

                                

Initial Description
Returns the last second of the day for a given datetime value (@date).

Initial Title
TSQL last second of day

Initial Tags

                                

Initial Language
SQL