Insert Timestamp Value in Table Results in ORA-01830: Date Format Picture Ends Before Converting Entire Input String (Doc ID 1509566.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.1.1.25.14 and later
Information in this document applies to any platform.

Symptoms

create table testdt
(ID                   NUMBER(2)     NOT NULL ,
DATTIJD_REGISTRATIE  TIMESTAMP(6)  NOT NULL);

Insert values in timestamp(6) column:
e.g.
insert into testdt (ID, DATTIJD_REGISTRATIE) values (20,'02-JAN-60 12.00.00.000000 AM');

results in:

Error starting at line 1 in command:
insert into testdt (ID, DATTIJD_REGISTRATIE) values (20,'02-JAN-60 12.00.00.000000 AM')
Error report:
SQL Error: ORA-01830: date format picture ends before converting entire input string
01830. 00000 - "date format picture ends before converting entire input string"
*Cause:
*Action:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms