Skip to content

Instantly share code, notes, and snippets.

@umair-me

umair-me/select_by_datetime.sql

Last active November 3, 2015 11:22
Show Gist options
  • Save umair-me/8692078 to your computer and use it in GitHub Desktop.
Save umair-me/8692078 to your computer and use it in GitHub Desktop.
Download ZIP
Get records between two 2 dates
Raw
select_by_datetime.sql
SELECT *
FROM TABLE
where datetime >= Convert(datetime, '2014-01-17 00:00:01', 120)
AND datetime <= Convert(datetime, '2014-01-17 23:59:01', 120)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment