topic Re: TalendDate.parse returns unexpected result in Talend Studio

TalendDate.parse returns unexpected result

Anonymous — Sat, 16 Nov 2024 14:23:31 GMT

The following expression,
TalendDate.parseDate("yyyy-MMM-dd HH:mm:ss", "23-Mar-1979 23:59:59")
gives me the output:
Fri Jul 30 23:59:59 CET 28
I wonder why is it giving me such an output.

OS: Windows XP
Current Locale: Sweden
Talend ETL : 2.3.1

Re: TalendDate.parse returns unexpected result

Anonymous — Mon, 21 Apr 2008 10:29:35 GMT

Hi Umair,
You try to parse a Date with a String value but a wrong DatePattern.
When you parseDate you need to have the same Pattern for your String value to parse in a Date object your data.
Best regards;

Re: TalendDate.parse returns unexpected result

Anonymous — Mon, 21 Apr 2008 10:54:37 GMT

Why does the above example not throw an exception?
Rgds

Re: TalendDate.parse returns unexpected result

Anonymous — Mon, 21 Apr 2008 11:03:22 GMT

Normally, it's throw an exception.
Maybe umair has not written the same expression that wrong result displayed.
Best regards,

Re: TalendDate.parse returns unexpected result

Anonymous — Mon, 21 Apr 2008 11:48:19 GMT

The example, TalendDate.parseDate("yyyy-MMM-dd HH:mm:ss", "23-Mar-1979 23:59:59")
is quoted in TalendDate routine comments.
But, now i changed the values and tried with the updated params:
TalendDate.parseDate("yyyy-mm-dd HH:mm:ss", "1979-04-11 23:59:59")
It now gives :
Thu Jan 11 23:59:59 CET 1979
The month is displayed as something else

Re: TalendDate.parse returns unexpected result

Anonymous — Mon, 21 Apr 2008 12:32:38 GMT

It's because your pattern is wrong, for month use the MM and not the mm (mm is for minute) in your Pattern.
Best regards.

Re: TalendDate.parse returns unexpected result

Anonymous — Mon, 21 Apr 2008 12:50:14 GMT

yes, that worked.
Thanx for your help

Re: TalendDate.parse returns unexpected result

Anonymous — Tue, 01 Nov 2011 08:50:12 GMT

Hi,
I have a date in following format.
Tue Nov 01 12:36:40 GMT+05:30 2011
I tried to parse it using following statement in tJava component
TalendDate.parseDate("yyyy-mm-dd HH:mm:ss",input_row.mtime_string);
This input_row.mtime_string string comes from tfileProperties.
It returns following exception
Exception in component tJavaRow_1
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Tue Nov 01 12:36:40 GMT+05:30 2011"
Whether am in missing something ?
Vaibhav

Re: TalendDate.parse returns unexpected result

Anonymous — Tue, 01 Nov 2011 10:06:19 GMT

Hi,
Solution to above query is following expression.
TalendDate.formatDate("yyyy-mm-dd hh:mm:ss",TalendDate.parseDate("EEE MMM dd HH:mm:ss Z yyyy","Tue Nov 01 12:36:40 GMT+05:30 2011"))
Contributed by Diwakar Nahata.
Thanks
Vaibhav

Re: TalendDate.parse returns unexpected result

Anonymous — Wed, 18 Sep 2013 16:08:33 GMT

Hi All,
TalendDate.ParseDate function in Talend to convert into Date Data type returns date in date data type but the date patterns is something else which is unexpected .
for eg.
I want to convert following string into date data type.
TalendDate.ParseDate("MM/dd/yyyy","09/18/2013")
The Above function returns me the date in date data type but the format of that is like "18-SEP-2013"
I want the output in "MM/dd/yyyy" means "09/18/2013" formats only.
can anyone suggest me how to overcome this issue.
Thank you in advance.
with kind regards,
Shailendra S.

Re: TalendDate.parse returns unexpected result

Anonymous — Thu, 19 Sep 2013 07:14:11 GMT

Re: TalendDate.parse returns unexpected result

Anonymous — Sun, 22 Sep 2013 04:09:13 GMT

Hi
Which is your output component? It is tLogRow? What's the date pattern on the schema? Set the date pattern to the format such as "MM/dd/yyyy" according to your need.

Shong