TRUNC

Returns the number x, truncated to d decimal places. If d is 0, the result has no decimal point or fractional part. d can be negative to cause d digits left of the decimal point of the value x to become zero. The maximum absolute value for d is 30; any digits in excess of 30 (or -30) are truncated.

If only provide x the default value of d is 0.

Syntax

TRUNC( x [, d] )

Examples

SELECT TRUNC(1.223, 1);

┌────────────────────┐
│ truncate(1.223, 1) │
├────────────────────┤
│ 1.2                │
└────────────────────┘

SELECT TRUNC(1.223)

╭─────────────────╮
│ truncate(1.223) │
├─────────────────┤
│               1 │
╰─────────────────╯