I am creating a job where below is the job flow
tRestClient->tExtractXMLField ->tXMLMap ->tMongoOutput
I am having an input date as shown below and please tell me how can i output in the ISODATE format
input date format -> 2006-10-05 14:34:58
expected output date format -> ISODate("2016-07-14T00:00:00.000+0000")
I don't understand why you use tXMLMap component in your job, I think you just a tMap to do some transformation. Try to parse the string to a Date with this expression on tMap:
TalendDate.parseDate("yyyy-MM-dd HH:mm[font=consolas, monaco, bitstream vera sans mono, courier new, courier, monospace]
:ss[/font]", row1.columnName)
In the output table, select 'Date' type for this column and set its date pattern as "yyyy-MM-dd'
T'HH:mm[font=consolas, monaco, bitstream vera sans mono, courier new, courier, monospace]
:ss[/font]
Z"