>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 #
980345Using 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)
If it's not broken, fix it until it is.
My Blog