TRUNC

Represents the SQLite TRUNC() function, which truncates a numeric value by removing its fractional part, effectively rounding it towards zero.

For example, TRUNC(5.9) returns 5, TRUNC(-5.9) returns -5, and TRUNC(5.0) returns 5.

The result is always returned as an integer type (Long). If the input is null or a value that cannot be converted to a number, the result is null.

Return

A KQLiteColumn of type Long with the truncated integer value.

Author

MOHAMMAD AZIM ANSARI

Parameters

x

The column containing the numeric value to truncate.

See also