0

Trying in Oracle SQL Developer

Column A is basically how my data is currently(timestamp with timezone) and I want to convert it to just timestamp

Input Output
2021-06-01T02:00:00-05:00 2021-06-01 07:00:00.000
2021-06-01T00:00:03-06:00 2021-06-01 06:00:03.000 
select TO_TIMESTAMP('2021-06-01T02:00:00-05:00','YYYY-MM-DD"T"HH24:MI:SSTZO') FROM dual
jarlh
  • 42,561
  • 8
  • 45
  • 63
Chinu
  • 39
  • 4
  • 1
    `select CAST(TO_TIMESTAMP_TZ('2021-06-01T02:00:00-05:00','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AT TIME ZONE 'UTC' AS TIMESTAMP) FROM dual` – MT0 May 02 '23 at 13:22

0 Answers0