1. 本地时间转换为国际标准时间 :
select current_timestamp at time zone 'UTC',
CAST(SYSDATE AS TIMESTAMP) at time zone 'UTC' ,
from dual ;
2. 国际标准时间转换为本地时间
select
CAST(SYSDATE AS TIMESTAMP) at time zone 'Asia/Shanghai',
FROM_TZ(CAST(SYSDATE AS TIMESTAMP), 'UTC') AT TIME ZONE 'Asia/Shanghai'
from dual ;