ROUND function [Numeric]

ROUND( numeric-expression, integer-expression )

numeric-expression The number, passed into the function, to be rounded.
integer-expression A positive integer specifies the number of significant digits to the right of the decimal point at which to round. A negative expression specifies the number of significant digits to the left of the decimal point at which to round.

NUMERIC

The result of this function is either numeric or double. When there is a numeric result and the integer integer-expression is a negative value, the precision is increased by one.

TRUNCNUM function [Numeric]

SQL/2008 Vendor extension.

The following statement returns the value 123.200:

SELECT ROUND( 123.234, 1 );

ROUND function [Numeric]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example