Skip to content

Instantly share code, notes, and snippets.

@bitsprint

bitsprint/Utils.Date.sql

Created September 17, 2013 09:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bitsprint/6592067 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bitsprint/6592067 to your computer and use it in GitHub Desktop.
Download ZIP
Round date to midnight
Raw
Utils.Date.sql
-- SQL 2008
DECLARE @CurrentDate DATETIME = (cast(GETDATE() as date))
-- Pre SQL 2008
DECLARE @CurrentDate DATETIME = DateAdd(Day, Datediff(Day, 0, GetDate()), 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment