Advanced Search

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