Skip to content

Instantly share code, notes, and snippets.

@hoffstein

hoffstein/gist:1089890

Created July 18, 2011 15:38
Show Gist options
  • Save hoffstein/1089890 to your computer and use it in GitHub Desktop.
Save hoffstein/1089890 to your computer and use it in GitHub Desktop.
Download ZIP
TSQL last second of day
Raw
gistfile1.sql
DATEADD(s, -1, DATEADD(d, 1, DATEADD(d, DATEDIFF(d, 0, @date), 0)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment