Oracle 11g Release 2

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

create table myTable (id number, Date_c varchar2(50));
insert into myTable values (1, '08/16/2019 08:09:51 AM');
1 rows affected

insert into myTable values (2, '08/16/2019 08:09:51 PM');
1 rows affected

insert into myTable values (3, '08/17/2019 02:00:00 PM');
1 rows affected

insert into myTable values (4, '08/17/2019 08:00:00 AM');
1 rows affected

select to_char(to_date(Date_c,'mm/dd/yyyy hh:mi:ss AM'),'mm/dd/yyyy hh:mi:ss AM') 
from myTable
order by to_date(Date_c,'mm/dd/yyyy hh:mi:ss AM');


TO_CHAR(TO_DATE(DATE_C,'MM/DD/YYYYHH:MI:SSAM'),'MM/DD/YYYYHH:MI:SSAM')


08/16/2019 08:09:51 AM

08/16/2019 08:09:51 PM

08/17/2019 08:00:00 AM

08/17/2019 02:00:00 PM