Assigns a time zone to a timestamp.
Syntax
FROM_TZ(ts, tz_str)Example
Enter values below to update the example in real time.
seoul_time→SELECT FROM_TZ(TIMESTAMP '2024-06-27 09:00:00', 'Asia/Seoul') AS seoul_time
FROM DUAL;
Assigns a time zone to a timestamp.
FROM_TZ(ts, tz_str)Enter values below to update the example in real time.
seoul_time→SELECT FROM_TZ(TIMESTAMP '2024-06-27 09:00:00', 'Asia/Seoul') AS seoul_time
FROM DUAL;