Tag: Datetime
-
Time Calculations (Rounding time to 00:00 or x minute)
This is a collection of sql code to enable the removal of time from a datetime, or the rounding to the nearest x minute (up or down) The rounding includes 5,6,10,15,20 and 30 minutes time periods, however the scripts are pretty straight forward to edit. The code should run on all versions of sql server,…