Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
NEW_TIME
NEW_TIME
The NEW_TIME() function is used to convert a date from timezone1 to a date in timezone2.
Syntax
NEW_TIME(date, timezone1, timezone2)
Example
SELECT new_time(TO_DATE('06-20-20 10:20:52', 'MM-DD-YY HH24:MI:SS'), 'EST','PST')