SQL Reference

ROUND

>>-ROUND--(--expression1--,--expression2--)--------------------><
 

The schema is SYSFUN.

Returns the expression1 rounded to expression2 places right of the decimal point. If expression2 is negative, expression1 is rounded to the absolute value of expression2 places to the left of the decimal point.

The first argument can be of any built-in numeric data type. The second argument can be INTEGER or SMALLINT. DECIMAL and REAL are converted to double-precision floating-point number for processing by the function.

The result of the function is:

The result can be null; if any argument is null, the result is the null value.

Example:


[ Top of Page | Previous Page | Next Page ]