>I have a value that represents duration, some of them are like 29, 14, 59. In my case these represent minutes, I'm looking for a way within a stored procedure to "round" them to the nearest 5 minute value.
>
>so 29 would become 30
>.. 14 would become 15
>.. 59 would become 60
>
>Thanks for any help.
>
>Kirk

Re: Round to nearest 5 Thread #980330 Message #980345

Using google to search

declare @dt datetime 

select @dt = '2006-09-14 08:01:32.700' 

select @dt, 
rounded = dateadd(minute, datediff(minute, 0, @dt) / 5 * 5, 0)