Community

How to round to the nearest whole multiple or fraction in SQL

(Baron Schwartz) Every once in a while, I find myself needing to round a number up to the nearest even power of 10, or round a time interval to the nearest quarter of an hour, or something like that. This is actually quite simple, but for some reason I always find myself confused about how to do it.

Read More - Register for Free Membership