topic Re: How to convert a string to a date. in Talend Studio

How to convert a string to a date.

RVeitch_84 — Sat, 16 Nov 2024 00:07:16 GMT

I have strings in the following formats that I would like to convert into a date.

2021-05-21T11:45:15Z

2021-05-25T18:59:27.513Z

I've tried tMap with the following with no luck.

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",row7.created_at);

Error:

Exception in component tXMLMap_1 (w_xpath_bu_testdev_wDB_dateformat)

java.lang.RuntimeException: java.text.ParseException: Unparseable date: "2021-05-25T20:23:27Z"

Re: How to convert a string to a date.

Anonymous — Wed, 26 May 2021 03:45:24 GMT

It seems the data has different date format, you can check the length of string first, and then use corresponding date pattern to parse the string and convert it to Date. eg:

row7.created_at.length()>20?TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",row7.created_at):TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'Z'",row7.created_at);

Re: How to convert a string to a date.

RVeitch_84 — Wed, 26 May 2021 19:07:15 GMT

Another question, how can I convert that parsed date into local time from:

row7.created_at.length()>20?TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",row7.created_at):TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'Z'",row7.created_at);

2020-09-27T22:34:03Z this is what I'm getting

2020-09-27 17:34:03 But I need it in this format?

I was thinking of doing something like this:

Thanks again.

Re: How to convert a string to a date.

Anonymous — Fri, 28 May 2021 09:15:39 GMT

If you are trying to convert UTC time to local time, please take a look at this topic and try the solution.

Let me know if it works.

Regards

Shong

Re: How to convert a string to a date.

RVeitch_84 — Fri, 28 May 2021 12:05:16 GMT

Thanks I ended up doing that same thing, see my example:

I had to add the option to look for a Null first.

Relational.NOT(Relational.ISNULL(row4.created_at1))?row4.created_at1.length()>20?TalendDate.parseDateInUTC("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",row4.created_at1):TalendDate.parseDateInUTC("yyyy-MM-dd'T'HH:mm:ss'Z'",row4.created_at1):TalendDate.parseDateInUTC("yyyy-MM-dd","0000-00-00");