date conversion error ORA-01830: date format picture ends before converting entire input string in jdbc

[#1]

Dear expert,

I am doing one scenario where oracle is the receiver. in the mapping  i have field entry_date my source date format is yyyymmdd  & i need to convert this into dd-mon-yy hh:mm:ss.

i used the date tranformation  logic dd-MMM-yy  HH:mm:ss.  and when i tested it's working fine. but when it reaches data base i am getting the  ORA-01830: date format picture ends before converting entire input string  in jdbc  eeror.

i tried the below link

http://scn.sap.com/message/13145628

In UDF which i need to select single values Or queue?

argument   or paramenter?

If we need UDF then tell me what is i need to do. please share the code & step by procedure i never used UDF.

Regards,

pavan

[Former Member]

Hi,

have you provided the date format in the Advanced tab as below?

first you try with the only date and explore TIME and TIMESTAMP options..