ROUND
The function ROUND returns a numeric value that round to the specific places.
| SQL Syntax: |
ROUND( number, places ) | |
| Number: |
Any numeric expression. | |
| Places: |
A integer expression that specified the precision. A positive value set the count of decimal places. A negative value set the count of decimal places left of the decimal point set are rounded. | |
| Escape Syntax: |
{fn ROUND( number )} | |
| Return Type: |
FLOAT | |
Examples:
SELECT ROUND(1.3456, 2), {fn round(-2012, -1)}
see also:
SQL Numeric Functions
CEILING
TRUNCATE