input value not long enough for date format
I recieved an error while inserting a date into my database. I fixed the first error with the date-format on my xsql page.
<xsql:insert-request xmlns:xsql="urn:oracle-xsql" table="vu_mat_product_msds_ingred"
connection="my_connection" date-format="yyyy/M/d" transform="msds_transform.xsl"/>
i then recieve the error:
error action="xsql:insert-request">
<message>Exception 'java.sql.SQLException:ORA-01840: input value not long enough for date format
Here is the element that it's failing on.
<CreationDate>1991/09/20</CreationDate>
How do I get around this error?