topic Re: How to convert string to date format in Talend Studio

How to convert string to date format

Anonymous — Sat, 16 Nov 2024 09:58:01 GMT

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")

Re: How to convert string to date format

Anonymous — Sun, 26 Mar 2017 05:13:43 GMT

Hello

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"

Let me know if it works.

Regards
Shong

Re: How to convert string to date format

Anonymous — Sun, 26 Mar 2017 18:14:07 GMT

Thanks Shong. I am able to parse the data.

-Supriya

Re: How to convert string to date format

Anonymous — Mon, 27 Mar 2017 09:47:32 GMT

Great, thanks for your feedback