Skip to content

Instantly share code, notes, and snippets.

@wammy67
Created July 17, 2017 10:29
Show Gist options
  • Save wammy67/7d698b2543ad9b48fe98d321afd0fb7f to your computer and use it in GitHub Desktop.
Save wammy67/7d698b2543ad9b48fe98d321afd0fb7f to your computer and use it in GitHub Desktop.
SELECT
createdate
FROM acc.ventries
WHERE cast(datepart(hour, createdate) as int) between 19 and 24
or cast(datepart(hour, createdate)as int) between 0 and 9
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment