Skip to Content
0
Former Member
Dec 13, 2007 at 02:54 PM

date format error in JDBC receiver

460 Views

Hi All,

I am doing a scenario File to JDBC. It works fine with string datatypes...

However when i try inserting date fields it gives me error:

<b>java.sql.SQLException: ORA-01861: literal does not match format string</b>

I am getting date in format : ddMMyyyy.

I thought it is error due to wrong date format so i used TransformDate function and converted to dd/MM/yyyy and now i am getting error:

<b>java.sql.SQLException: ORA-01843: not a valid month</b>

Can anybody tell me why is this error coming? How can i find out exact date format required to database?

thanks,

Atul