This content has been marked as final. Show 4 replies
have a look here
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.
Edited by: Soli on 17.8.2009 10:02