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 FEBRUARY 28, 2025
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle SQL Developer - Version 1.1.1.25.14 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |