Skip to content

Instantly share code, notes, and snippets.

@monyskynet
Created July 26, 2013 02:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save monyskynet/6085463 to your computer and use it in GitHub Desktop.
Save monyskynet/6085463 to your computer and use it in GitHub Desktop.
Get Row in Date range
AND ClickedDate BETWEEN '01/03/2012' AND '12/03/2013'
-- OR
AND DATEADD(DAY, DATEDIFF(DAY, 0, ClickedDate), 0) BETWEEN '01/03/2012' AND '12/03/2013'
--OR
AND ClickedDate >= '01/03/2012' AND ClickedDate <= '12/03/2013'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment