clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3799226 fiddles created (41712 in the last week).

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


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


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
 hidden batch(es)