ORA-01830: date format picture ends before converting entire input string

I got ” ORA-01830: date format picture ends before converting entire input string ” error in Oracle database.

ORA-01830: date format picture ends before converting entire input string

Details of error are as follows.

ORA-01830 date format picture ends before converting entire input string

Cause: A valid date format picture included extra data. The first part of the format 
picture was converted into a valid date, but the remaining data was not required.

Action: Check the specifications for date format pictures and correct the statement.

date format picture ends before converting entire input string

This ORA-01830 errors are related with the valid date format picture included extra data. The first part of the format
picture was converted into a valid date, but the remaining data was not required.

To solve this error, you need to use nls_date_format as follows.

alter session nls_date_format='DD/MM/YYYY HH:MM:SS AM';

Or use the TO_DATE function as follows.

insert into test values (TO_DATE('2008-12-23T17:28:44','YYYY-MM-DD"T"HH24:MI:SS'));

If you want to learn more details , Read the following post.

Do you want to learn Oracle Database for Beginners, then read the following articles.