Hello,
I shared the data input, it needs to be converted of one utc time format and another one cdt time format that shows two different column.
input :
with sqltmp as (
select sysdate date1,'08:00' start1,'23:01' end1,'US/Eastern' DB_TZ from dual union all
select sysdate+1 date1,'23:00' start1,'23:01' end1,'US/Eastern' DB_TZ from dual union all
select sysdate+2 date1,'11:00' start1,'23:01' end1,'US/Eastern' DB_TZ from dual )
SELECT * FROM SQLTMP;
Thanks