How to Round Up by Quarter Hour in T-SQL

If life should ever punish you by challenging you to round up decimals by a quarter of an hour – always up and never down – here’s a liferaft

In a scenario where you wish for 2.04 to be rounded up to 2.25 instead of down to 2.00:

This solution is based on the solution posted in 2001 on VBForums – props to original poster MartinLiss!


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.