DIGITS

The DIGITS function returns a character string representation of the absolute value of a number.

numericExpression must return a value that is a SMALLINT, BIGINT, INTEGER, or DECIMAL built-in numeric data type.

The following table describes the output lengths for the BIGINT function:

Data type	Output length
SMALLINT	5
BIGINT	19
INTEGER	10
DECIMAL	p if the argument is a decimal with a precision of p

Important

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

On this page