Skip to content

Instantly share code, notes, and snippets.

@anataliocs

anataliocs/dates.txt

Created October 23, 2013 19:00
Show Gist options
  • Save anataliocs/7124582 to your computer and use it in GitHub Desktop.
Save anataliocs/7124582 to your computer and use it in GitHub Desktop.
Download ZIP
SQL date conversions date range
Raw
dates.txt
WHERE DATE BETWEEN '09/16/2010 05:00:00' and '09/21/2010 09:00:00'
Convert SQL Server timestamp into date
CONVERT(char(10), Dateadd(second, (createStamp/1000), '01/01/1970'), 101) as Created
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment