8.2.26. TRUNC()
Available in
DSQL, PSQL
Syntax
TRUNC (number [, scale])
Parameter | Description |
---|---|
number | An expression of a numeric type |
scale | An integer specifying the number of decimal places toward which truncating is to be performed, e.g.:
|
Result type
INTEGER
, (scaled) BIGINT
or DOUBLE PRECISION
Description
Returns the integer part of a number. With the optional scale argument, the number can be truncated to powers-of-ten multiples (tens, hundreds, tenths, hundredths, etc.) instead of just integers.
Notes
If the scale argument is present, the result usually has the same scale as the first argument, e.g.
TRUNC(789.2225, 2)
returns 789.2200 (not 789.22)TRUNC(345.4, -2)
returns 300.0 (not 300)TRUNC(-163.41, 0)
returns -163.00 (not -163)
Otherwise, the result scale is 0:
TRUNC(-163.41)
returns -163
If you are used to the behaviour of the external function TRUNCATE, please notice that the internal function |