ORA:01821: Date format not recognized while inserting the record

Question

I am trying to insert a row in my oracle table, but it is giving error 'Date format not recognized'. Details are as below. What is wrong in this?

create table "employee" ( 
     "emp_id" VARCHAR2(100 BYTE),
     "emp_name" VARCHAR2(100 BYTE),
     "hired_date" Date,
     CONSTRAINT "PK_employee" PRIMARY KEY ("emp_id")
);

Insert into employee values ( 'A1234', 'John Day', TO_DATE('07/20/2020 15:05:20', 'MM/DD/YYYY H24:MI:SS'));

It's not a good idea to force database object names to a specific case, unless your application specifically requires it. If you just name the table employee then it will be case-insensitive and much easier to work with. — William Robertson

JagaSrik JagaSrik · Accepted Answer · 2020-07-22T05:33:20

You are missing one 'H' use 'HH24'

Insert into "employee" values ( 'A1234', 'John Day', TO_DATE('07/20/2020 15:05:20', 'MM/DD/YYYY HH24:MI:SS'));

ORA:01821: Date format not recognized while inserting the record

2 Answers