CAST_NUMERIC_TO_TIMESTAMP_TZ_UDF (NUMBER)
Definition
This user-defined function (UDF) is used to cast a numeric value to timestamp_tz.
CAST_NUMERIC_TO_TIMESTAMP_TZ_UDF(INPUT NUMBER)Parameters
INPUT NUMBER
The number to be cast.
Returns
Returns a timestamp_tz with the current timezone.
Usage example
Input:
SELECT PUBLIC.CAST_NUMERIC_TO_TIMESTAMP_TZ_UDF(0)Output:
1900-01-01 01:00:00.000 +0100Last updated