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