Hi Experts,
I am getting ORA-01857: not a valid time zone error while running below statment.
The string 'Tue Mar 12 02:46:37 EDT 2024' is coming from one of the table column and it to be converted to GMT.
SELECT TO_CHAR(TO_TIMESTAMP_TZ('Tue Mar 12 02:46:37 EDT 2024','dy mon dd hh24:mi:ss tzd yyyy')AT TIME ZONE 'GMT','yyyy-mm-dd hh24:mi:ss tzr') FROM DUAL;