SQL Reference

TRUNCATE or TRUNC

>>-+-TRUNCATE-+--(--expression--,--expression--)---------------><
   '-TRUNC----'
 

The schema is SYSFUN.

Returns argument1 truncated to argument2 places right of decimal point. If argument2 is negative, argument1 is truncated to the absolute value of argument2 places to the left of the decimal point.

The first argument can be any built-in numeric data type. The second argument has to be an INTEGER or SMALLINT. DECIMAL and REAL are converted to double-precision floating-point number for processing by the function.

The result of the function is:

• INTEGER if the first argument is INTEGER or SMALLINT
• BIGINT if the first argument is BIGINT
• DOUBLE if the first argument is DOUBLE, DECIMAL or DOUBLE.

The result can be null; if any argument is null, the result is the null value.