Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions

 

ROUND function [Numeric]

Rounds the numeric-expression to the specified integer-expression amount of places after the decimal point.

Syntax
ROUND( numeric-expression, integer-expression )
Parameters
  • 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.

Remarks

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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value 123.200.

SELECT ROUND( 123.234, 1 );