Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test(dat_col varchar(200));
insert into test values('1/16/2020 6:28:44 AM -08:00');
1 rows affected

insert into test values('11/8/2019 3:20:30 AM -05:00');
1 rows affected

insert into test values('10/25/2019 6:08:21 PM +05:30');
1 rows affected

select * from test;

DAT_COL

1/16/2020 6:28:44 AM -08:00

11/8/2019 3:20:30 AM -05:00

10/25/2019 6:08:21 PM +05:30

select CAST(to_timestamp_tz (dat_col, 'MM/DD/YYYY HH12:MI:SS AM TZH:TZM' ) AS DATE) 
from test

CAST(TO_TIMESTAMP_TZ(DAT_COL,'MM/DD/YYYYHH12:MI:SSAMTZH:TZM')ASDATE)

16-JAN-20

08-NOV-19

25-OCT-19

select to_timestamp_tz (dat_col, 'MM/DD/YYYY HH12:MI:SS AM TZH:TZM' ) 
from test

TO_TIMESTAMP_TZ(DAT_COL,'MM/DD/YYYYHH12:MI:SSAMTZH:TZM')

16-JAN-20 06.28.44.000000000 -08:00

08-NOV-19 03.20.30.000000000 -05:00

25-OCT-19 18.08.21.000000000 +05:30