T-SQL - Date rounding and normalization
- by arun prakash
Hi:
I have a stored procedure that rounds a column with dates in (yyyy:mm:dd hh:mM:ss) to the nearest 10 minute handle (yyyy:mm:dd hh:mM)
20100303 09:46:3000 ------ 20100303 09:50
but i want to chage it to round it off to the nearest 15 minute handle:
20100303 09:46:3000 ------20100303 09:45
here is my code :
IF…