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')