|
|
|
|
|
|
TRUNC returns a value representing the argument fully truncated (toward zero) or truncated to a specific number of decimal places.
Syntax
TRUNC ( expression [ , places ]
Semantics
expression |
is an expression of type INTEGER or DOUBLE PRECISION that represents the number to truncate |
places |
is an expression of type INTEGER specifies the number of decimal places to return |
Examples
TRUNC(42.8)
Result: 42
TRUNC(42.4382, 2)
Result: 42.43