使用oracle SQL developer将GMT转换为定位日期

SQL> with t as
  2  ( select to_timestamp('Mon Jan 25 2021 15:01:07','Dy Mon DD YYYY HH24:MI:SS') d
  3    from dual
  4  )
  5  select from_tz(d,'CST') at time zone 'Australia/Perth'  from t;

FROM_TZ(D,'CST')ATTIMEZONE'AUSTRALIA/PERTH'
---------------------------------------------------------------------------
26-JAN-21 05.01.07.000000000 AM AUSTRALIA/PERTH
复制