TRUNCATE
Truncates the given input to a given number of decimal places.
Syntax
TRUNCATE(X [, N])
Arguments
X
Type: numeric
A numeric value.
N
Type: integer
Default: 0
The number of decimal places to keep. This can be negative to truncate N digits left of the decimal point.
If omitted, the precision defaults to 0 and X is rounded to the nearest integer.
Returns
Type: double
X truncated to PRECISION decimal places.
Examples
| X | Precision | Output |
|---|---|---|
| 2.365 | 2.0 | |
| 1.456249 | 3 | 1.456 |
| 42.01934 | 2 | 42.01 |
| 1.1 | 1.0 | |
| -1.1 | -1.0 | |
| -1.9 | -1.0 | |
| 0 | 0.0 | |
| 0.5 | 0.0 | |
| 12.333 | -1 | 10.0 |
| 12.333 | 0 | 12.0 |
| 12.333 | 1 | 12.3 |