>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

select round(29/5.0,0)*5 -- 30
, round(14/5.0,0)*5	-- would become 15
, round(59/5.0,0)*5	--would become 60
, round(56/5.0,0)*5	--would become 55