ROUND

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


ROUND (arithmetic_expression[, arithmetic_expression])

Description

The ROUND function rounds the first arithmetic_expression passed to "x" decimal places (where "x" is the second optional arithmetic_expression passed). If the second arithmetic_expression is not passed, the arithmetic_expression is rounded off to the nearest whole number.

Example

This example rounds the given number off to two decimal places:

   ROUND (1234.1966, 2) 
       `returns 1234.2000

See Also

TRUNC, TRUNCATE.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next