Message: ORA-01861: literal does not match format string

[Anonymous]

Hi all, 

in talend, im doing the integration, and when i run the job, i am facing this issue, 
can anyone please help me with this?? 

this is the exact error that it is showing

================================================

Starting job tfileinput at 11:56 07/11/2017.

[statistics] connecting to socket on port 3863
[statistics] connected
SQLState: 22008
Error Code: 1861
Message: ORA-01861: literal does not match format string
SQLState: 22008
Error Code: 1861
Message: ORA-01861: literal does not match format string
[statistics] disconnected
Job tfileinput ended at 11:56 07/11/2017. [exit code=0]

=========================================================

Thanks and Regards

Rak**bleep**a

[Anonymous]

Are you trying to insert any date formatted data?

[Anonymous]

yes..im using the tmap component in talend, im mapping the columns accordingly

the fields im using are 

LastUpdateDate

CreationDate and others

[Anonymous]

Actually in SOAPUI response side, i am getting

<ns2:LastUpdateDate>2017-11-07T06:44:16.081Z</ns2:LastUpdateDate>

and  2017-11-07T06:44:16.081Z i'm trying to insert in database which is in 20-08-17 format,

so how to resolve this, can you please tell me

[Anonymous]

Please mention the date pattern for above field as "yyyy-MM-dd'T'HH:mm:ss.SSSZ" in oracle component schema

[Anonymous]

i hard coded this value in the tmap component,

didn't work