![]() Previous |
![]() Next |
When you specify a number as an argument, the TRUNCATE function truncates a number to a specified number of decimal places.
Return Value
DECIMAL
Syntax
TRUNC (number, truncvalue)
Parameters
The number to truncate. The value specified for number must be followed by a comma.
An INTEGER
value that specifies the number of places to the right or left of the decimal point to which number should be truncated. When truncvalue is positive, digits to the right of the decimal point are truncated. When it is negative, digits to the left of the decimal point are truncated (that is, made zero). When truncvalue is omitted, number is truncated to 0
decimal places.
Examples