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.