trunc
The trunc function truncates a given number to the specified precision, without rounding the value.
Category
Math
Return value
decimal, double, int, or real
The truncated number. The return data type is the same as the data type of <number>.
Where
|
<number> |
The number from a source column. |
|
<precision> |
The number of decimals in the result. If <precision> is negative, the software truncates the digits to the left of the decimal point and pads the value with zeros. |