ROUND(n[,m])
Returns the rounded value of n based on the value of m. If n is a numeric value, it can be either positive or negative.
- A positive value m specifies the digits to the right of the decimal point.
- A negative value m specifies the digits to the left of the decimal point.
- If m is 0 or not specified, the value is rounded at the decimal point.
- If n is a date value, m can be one of the following:
| SCC,CC |
Century |
| SYYY, YYYY, YEAR, SYEAR, YYY, YY, Y |
Year |
| Q |
Quarter |
| MONTH, MON, MM |
Month |
| WW,W |
Start of Week |
| DDD,DD,J (default) |
Day |
| DAY, DY, D |
Nearest Sunday |
| HH, HH12, HH24 |
Hour |
| MI |
Minute |