we have requirement to change the time zone format of the data (UTC to CST) from the column and oracle provided solution to convert the time zones.
Here is the function that you should use to convert the timezone:
to_char(NEW_TIME(SCHEDULED_TIME,'GMT','CDT'), 'dd-mm-yy hh:mi:ss')
old time zone data:
WORK_NAME JOB_NAME NEWTIME_TEST
---------------- ---------------- --------------------
servername124 FINAL 06-09-22 03:29:00 PM
new time zone data:
WORK_NAME JOB_NAME NEWTIME_TEST
---------------- ---------------- --------------------
servername124 FINAL 07-09-22 10:29:00 AM
