SWITCHOFFSET_UDF (TIMESTAMP_TZ, VARCHAR)
Definition
This user-defined function (UDF) returns a new timestamp_tz with the adjusted time taken for parameter target_tz.
Parameters
source_timestamp
TIMESTAMP_TZ
The source timestamp to adjust.
target_tz
varchar
The target time to take.
Returns
Returns the formatted target time as TIMESTAMP_TZ.
Usage example
Input:
Output:
Last updated