Q
Problem solve Get help with specific problems with your technologies, process and projects.

Cause of ORA-01830 error

I have two users who are getting the error "ORA-01830: date format picture ends before converting entire input string." Looking at the output from the precompiler, the code looks correct. My only assumption is that the strings comprising the date format are being corrupted.

I have two users who are getting the error "ORA-01830: date format picture ends before converting entire input string." This is happening on both a HP9000 and HP Itanium using both Oracle 8 and 9. Looking at the output from the precompiler, the code looks correct. My only assumption is that the strings comprising the date format are being corrupted. Can you think of anything else?
The ORA-1830 error is thrown when the data being converted to a date datatype contains extra characters not shown in the date format. As an example, look at the following TO_DATE function call:
TO_DATE('12/13/2005 13:43:56','MM/DD/YYYY HH24:MI')
In the example above, I have the month, the date, the year, the hour, the minutes and the seconds. But the seconds are not included in the date format mask, 'MM/DD/YYYY HH:24:MI.' This format mask is shorter than the given value. So Oracle is telling you that this format picture ends before the entire input string has been converted to the DATE datatype. Double check your format mask and the value being applied to this format mask. You probably have extra characters there. Some characters, such as the tab character, may be invisible, so you might want to check the ASCII code of the value to ensure that there are not hidden characters.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close