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


100% pure Java DBMS
Mirror Site