Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

TalendDate.parse returns unexpected result

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
Labels (2)
11 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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
0683p000009MC76.png