TRUNCATE

All functions > MATH > TRUNCATE

Returns the integer part of a number by truncating the fractional part.

Signatures

Returns: Integer result after truncation

TRUNCATE(number: T) → BIGINT

Notes

• Removes the fractional part, rounding towards zero
• TRUNCATE(2.9) = 2, TRUNCATE(-2.9) = -2
• Different from FLOOR for negative numbers
• TRUNCATE(-2.9) = -2 vs FLOOR(-2.9) = -3
• Returns NULL if the input is NULL
• Also known as "truncation" or "chopping"

Examples

SELECT
    f1 := TRUNCATE(2.1e0),  -- Positive truncates towards zero
    f2 := TRUNCATE(2.9e0),  -- Removes decimal part
    f3 := TRUNCATE(-2.1e0),  -- Negative truncates towards zero
    f4 := TRUNCATE(-2.9e0),  -- Different from FLOOR
    f5 := TRUNCATE(3.14159e0),  -- Pi truncated
    f6 := TRUNCATE(-3.14159e0)  -- Negative pi truncated
;