Posted By

hoffstein on 10/14/08

Tagged

Viewed 1635 times

Favorited by 1 user(s)

/ Published in: SQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

DATEADD(s, -1, DATEADD(d, 1, DATEADD(d, DATEDIFF(d, 0, @DATE), 0)))

You need to login to view comments.