Date Format ErrorUrgent Help Needed


I am a webMethods rookie…Can anybody tell me how to solve this problem…

I am inserting the data into oracle and before insertion I am converting the date to oracle format…i.e.,

Original DateField(Registration_Date)--------- 20041118(yyyyMMdd)
So I used datetimeformat of wMPublic to convert the date to oracle format i.e., yyyy-MM-dd hh:mm:ss

Now when I am trying to insert I am getting the below error…Can u tell me what date format oracle is expecting…

An error occurred while tracing. [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service newcorp.fpl.TeleMarketing.db:insertWhTransaction.
[ADA.1.314] Cannot set data for the input field “REGISTRATION_DATE”
Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff


Please check this link,a similar kind of issue

And make sure you are not doing like srivats mistake and finally he found the bug in the mapping itself.

This is sure a mapping problem not related to JDBC Adapter or Oracle.



I resolved this issue. I used the below format.
yyyy-MM-dd 00:00:01 a

Thank You,


yes this format works yyyy-MM-dd HH:mm:ss.

Glad you solved.