ADD_TIME_ZONE_OFFSET
Add a timezone offset to a date. The timezone offset can be in any of the standard formats accepted by Java's ZoneId.of method (America/New_York, +02:00, etc.)
ADD_TIME_ZONE_OFFSET(time, zone)
Name | Type | Description | Default Value |
|---|---|---|---|
time | timestamp | | |
zone | string | | |
timestamp
time | zone | Output |
|---|---|---|
timestamp '2018-03-10 08:55:12.456' | '+02:00' | timestamp '2018-03-10 10:55:12.456' |
timestamp '2018-03-10 08:55:12.456' | 'America/New_York' | timestamp '2018-03-10 03:55:12.456' |
timestamp '2018-03-10 08:55:12.456' | '' | null |
timestamp '2018-03-10 08:55:12.456' | 'Invalid Zone Id' | null |
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT time, zone,
ADD_TIME_ZONE_OFFSET(time, zone) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET time = timestamp '2018-03-10 08:55:12.456',
zone = '+02:00'
WHERE time_filter()
LIMIT 1;
time | zone | Output |
|---|---|---|
timestamp '2018-03-10 08:55:12.456' | '+02:00' | timestamp '2018-03-10 10:55:12.456' |
Last modified 28d ago