radleta/NearestHour.sql

Created December 24, 2013 13:25

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/radleta/8113319.js"></script>
Save radleta/8113319 to your computer and use it in GitHub Desktop.

Download ZIP

Round DateTime to nearest hour. Useful when grouping by DateTime to round to the nearest hour.

Raw

NearestHour.sql

SELECT dateadd(hour, datediff(hour, 0, GETDATE()), 0) NearestHour

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment