ToZonedDateTime
The ToZonedDateTime function converts the input string, date, or date_time to the zoned_date_time data type. The zoned_date_time data type allows the use of UTC timezone offset and zone id information with time values and is based on Java’s ZonedDateTime class (https://docs.oracle.com/javase/8/docs/api/java/time/ZonedDateTime.html).
Syntax
ToZonedDateTime(<String>|<date>|<date_time>|<offset_date_time>|<instant> [,<zoned_date_time_mask>]) |
Return Type
zoned_date_time
Details
Zoned_date_times contain UTC timezone offset and id information lacking from other data types such as date_time, instant, andoffset_date_time. Unless you need to store values with different timezone information, Xactly recommends using the instant data type instead.
Examples
eval ToZonedDateTime('September 22, 2016 Thursday 03:24:29 +01:00', 'MMMM dd, yyyy EEEE HH:mm:ss XXXXX');
eval ToZonedDateTime('September 22, 2016 Thursday 03:24:29 +00:00', 'MMMM dd, yyyy EEEE HH:mm:ss XXXXX');
select Now() as now, TypeNameOf(Now()) as TypeNameOf_now, ToZonedDateTime(Now()) as cast_to_offset_date_time, TypeNameOf(ToZonedDateTime(Now())) as TypeNameOfCast from Empty();
eval ToZonedDateTime('December 03, 2014 Wednesday 10:15:30 CET', 'MMMM dd, yyyy EEEE HH:mm:ss z');
eval ToZonedDateTime('December 03, 2014 Wednesday 10:15:30 Asia/Kolkata', 'MMMM dd, yyyy EEEE HH:mm:ss zzz');
eval ToZonedDateTime('2014-09-15 23:15:30 Australia/Sydney', 'yyyy-MM-dd HH:mm:ss zzz');
eval ToZonedDateTime('2014-09-15 23:15:30 AEST', 'yyyy-MM-dd HH:mm:ss z');
