WithZoneSameDateTime
Use the WithZoneSameDateTime function to add a timezone id or name to a date/date time value.
Syntax
WithZoneSameDateTime(<date>|<date_time>|<instant>|<offset_date_time>|<zoned_date_time> [,<string>]) |
The second string input parameter takes a Java zone_id or zone_name. Refer to Java docs for a list of valid zone id and name values.
Return Type
zoned_date_time
Details
Warning: The function alters the timezone id or name information for the input parameter. Any time values are retained verbatim when the first input parameter is an instant, offset_date_time, or zoned_date_time data type, i.e. the input parameter already has timezone information. The function simply alters the timezone id/name. Use WithZoneSameInstant to realign time stamp values along with timezone changes.
Examples
select CurDateTime(), TypeNameOf(CurDateTime()), WithZoneSameDateTime(CurDateTime(), 'America/Chicago'), TypeNameOf(WithZoneSameDateTime(CurDateTime(), 'America/Chicago')) from Empty();
Select ToZonedDateTime('2016-10-19T14:11:07.790-05:00[America/Chicago]') as time_stamp_orig,
WithZoneSameDateTime(ToZonedDateTime('2016-10-19T14:11:07.790-05:00[America/Chicago]'), 'America/Denver') as time_stamp_unchanged
from Empty();
