Date Formatting error in JDBC adapter

[former_member210730]

Hi,

While inserting date using a Receiver JDBC Adapter i am getting a "Month not valid" error can anyone please tell me how do i pass date in the required format. Database is Oracle.

[prateek]

Hi Vinay,

Oracle's default format for DATE is "DD-MON-YY"

With the functions to_char and to_date, a date format can be used. Example:

select to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') from dual;

will return something like: 24/03/2006 14:36:43

Regards,

Prateek

[bhavesh_kantilal]

Check this blog and try what is explain in this blog or make sure that the date is as expected in the mapping putput,.

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

Regards

Bhavesh