Syntax¶

AS_TIME(<variant_expr>)

Arguments¶

variant_expr

An expression that evaluates to a value of type VARIANT.

Returns¶

The function returns a value of type TIME or NULL:

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

• 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.

Examples¶

Create a table and load data into it:

CREATEORREPLACETABLEas_time_example(time1VARIANT);INSERTINTOas_time_example(time1)SELECTTO_VARIANT(TO_TIME('12:34:56'));

Use the AS_TIME function in a query to cast a VARIANT value to a TIME value:

SELECTAS_TIME(time1)AStime_valueFROMas_time_example;

+------------+| TIME_VALUE ||------------|| 12:34:56   |+------------+