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.
检查字段的值,看来不只是2014-4-1这样的格式,部分还带了时间吧