AS_INTEGER¶

Casts aVARIANT value to anINTEGER. The function doesnot cast non-integer values.

The INTEGER data type is synonymous with theNUMBER data type, except that precisionand scale can’t be specified for INTEGER values.

See also:

AS_<object_type>

Syntax¶

AS_INTEGER(<variant_expr>)

Copy

The function returns a value of type INTEGER or NULL:

If the type of the value in thevariant_expr argument is INTEGER, the function returns a value of type INTEGER.

If the type of the value in thevariant_expr argument doesn’t match the type of the outputvalue, the function returns NULL.
If thevariant_expr argument is NULL, the function returns NULL.

Create a table and load data into it:

CREATEORREPLACETABLEas_integer_example(integer1VARIANT);INSERTINTOas_integer_example(integer1)SELECTTO_VARIANT(15);

Copy

Use the AS_INTEGER function in a query to cast a VARIANT value to an INTEGER value:

SELECTAS_INTEGER(integer1)ASinteger_valueFROMas_integer_example;

Copy

+---------------+| INTEGER_VALUE ||---------------||            15 |+---------------+