I got ” ORA-01840 input value not long enough for date format ” error in Oracle database.
ORA-01840 input value not long enough for date format
Details of error are as follows.
ORA-01840 input value not long enough for date format Cause: The data to be converted to date format was incomplete; the date format picture was longer than the input data. Action: Either add more input or shorten the date picture format, then retry the operation.
input value not long enough for date format
This ORA-01840 errors are related with the data to be converted to date format was incomplete; the date format picture was longer than the input data.
Either add more input or shorten the date picture format, then retry the operation.
You should use the NLS_DATE_FORMAT in your conversions.
You should check if column data types should be DATE, if all columns of type are not DATE, then you should use the to_date() function. Don’t rely on implicit conversions.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )