Oracle 11g Release 2

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

CREATE TABLE your_file ( delivery_date ) AS
SELECT '02/09/2020 15:30:00 PM' FROM DUAL;
1 rows affected

SELECT TO_TIMESTAMP( delivery_date, 'MM/DD/YYYY HH24:MI:SS AM' )
FROM   your_file;
ORA-01818: 'HH24' precludes use of meridian indicator

SELECT TO_TIMESTAMP( SUBSTR( delivery_date, 1, 19 ), 'MM/DD/YYYY HH24:MI:SS' )
FROM   your_file;


TO_TIMESTAMP(SUBSTR(DELIVERY_DATE,1,19),'MM/DD/YYYYHH24:MI:SS')


09-FEB-20 03.30.00.000000000 PM