topic Date Parsing... in Talend Studio

Date Parsing...

Anonymous — Fri, 25 Jan 2019 08:23:49 GMT

I'm having real trouble converting an input string of

2010-01-26T00:00:00

to a date string YYYY-MM-DD

The issue in my dateParse is the T - can't work out the for life of me how to set the input format in the parsing to convert to what I need.

Any help would be great.

Thanks

Dave

Re: Date Parsing...

ThWabi — Fri, 25 Jan 2019 08:54:38 GMT

Hi Dave,

I think this should work:

your_date = TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss", your_input_string)
your_output_string = TalendDate.formatDate("yyyy-MM-dd", your_date)

Best regards,

Thomas

Re: Date Parsing...

Anonymous — Fri, 25 Jan 2019 09:34:50 GMT

that worked - thanks. I was going round in circles...

Re: Date Parsing...

ankit7359 — Fri, 25 Jan 2019 09:37:20 GMT

Hi @DaveG2008 ,

you can convert string to date by using talenddate.parsedate method and if you want the vice - versa (Date to string) - then use talenddate.formatdate method.

Pls check the below screen shots -

resulttmaprow generator and date as string value

---> TalendDate.parseDate("yyyy-MM-dd",row1.Date) <------

Pls get back to Community, if necessary.

Thanks,

Ankit.

Re: Date Parsing...

Anonymous — Thu, 28 Feb 2019 19:31:31 GMT

Should have replied earlier. This worked perfectly - thanks for the help.