topic Re: Convert to Date 2017-09-06T23:10:25Z in Talend Studio

Convert to Date 2017-09-06T23:10:25Z

AlmendSR — Sat, 16 Nov 2024 09:16:10 GMT

I'm receiving a date string in the following format but I can't find a way to convert it using parseDate. I've tried a bunch of different format strings.

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",Var.var1)

Re: Convert to Date 2017-09-06T23:10:25Z

Anonymous — Thu, 21 Sep 2017 06:57:21 GMT

Hi,

Can you post some examples of date strings you're receiving? Then i'll give it a go here.

Where are you receiving them from?

Re: Convert to Date 2017-09-06T23:10:25Z

Anonymous — Thu, 21 Sep 2017 07:07:42 GMT

Hi,

Just realized you had an example in the subject of your message.

The following seems to work, I removed the milleseconds from the format ('SSS') as they are not in your example date.

System.out.println(TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'Z'","2017-09-06T23:10:25Z"));

Result : Wed Sep 06 23:10:25 CEST 2017

Hope this helps!

Re: Convert to Date 2017-09-06T23:10:25Z

shivanand — Thu, 21 Sep 2017 07:08:52 GMT

Try this

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",Var.var1)

Re: Convert to Date 2017-09-06T23:10:25Z

AlmendSR — Thu, 21 Sep 2017 14:28:28 GMT

That did it! thank you.