topic Re: TalendDate format string for timestamp with timezone in Talend Studio

TalendDate format string for timestamp with timezone

mario_mirabile — Wed, 12 Jun 2013 07:15:31 GMT

Hi
I have the following code in a tMap - TalendDate.parseDate("yyyy-MM-dd'T'hh:mm:ssz", stgTVP6.MOMENT ) .
When it runs, I get the following error
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "2004-08-12T00:00:00+09:30"
Can someone help me with the correct format string for a timestamp string with the format "2004-08-12T00:00:00+09:30".
Thanks
Mario

Re: TalendDate format string for timestamp with timezone

Anonymous — Wed, 12 Jun 2013 08:05:06 GMT

try this one
String date = "2004-08-12T00:00:00+09:30".replaceAll("\\+0(){1}\\:00", "+0$100");
System.out.println( TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ssZ", date));

Re: TalendDate format string for timestamp with timezone

mario_mirabile — Thu, 13 Jun 2013 06:59:03 GMT

Thanks, but I'm still getting exactly the same error. When I check the effect of the replaceAll on the input value, it hasn't changed the input string at all.
I'm not very good at regular expressions - what are you trying to replace, and with what?

Re: TalendDate format string for timestamp with timezone

alevy — Fri, 14 Jun 2013 01:34:27 GMT

"z" in a date format string is e.g. GMT, PST. "Z" in a date format string is a time offset e.g. +1000. So you should just need to get rid of the ":" in the time offset and change your date format string to use "Z".
Try:
TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ssZ", stgTVP6.MOMENT.replaceAll(" \\d{2})$","$1"));

Re: TalendDate format string for timestamp with timezone

mario_mirabile — Fri, 14 Jun 2013 03:40:10 GMT

Thanks.
That worked insofar as as making the timestamp value palatable to Talend. The problem is that ParseDate now insists on converting the time zone from +9:30 (South Australia) to Eastern European time!!

Re: TalendDate format string for timestamp with timezone

alevy — Mon, 17 Jun 2013 12:31:32 GMT

How do you mean?

Re: TalendDate format string for timestamp with timezone

mario_mirabile — Tue, 18 Jun 2013 01:54:32 GMT

I mean that if I give it a value of "2013-06-16T10:00:00+09:30", I get back a value of "2013-06-16T03:00:00+0300" - both effectively the same time, but one is in Adelaide and the other in Eastern Europe - possibly Prague, but it could be Budapest.

Re: TalendDate format string for timestamp with timezone

alevy — Wed, 19 Jun 2013 05:04:28 GMT

I can only imagine that the machine you're running the job on thinks it's in the +3 timezone.