TRUNC_UDF (NUMBER)

Definition

This user-defined function (UDF) reproduces the Teradata and Oracle TRUNC(Numeric) functionality when a scale is not specified.

TRUNC_UDF(INPUT NUMBER)

INPUT NUMBER

The number to truncate.

Returns an int as the input truncated to zero decimal places.

Input:

SELECT TRUNC_UDF(25122.3368)

Output:

Last updated 10 months ago