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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

String to Date Conversion in Talend

How to Convert this "Tue, 26 Jun 2018 09:00:15 -0500" {Datatype - String} into "20180626" {Datatype - String
and another is 

How to Convert this "Wed Jun 27 15:57:11 IST 2018" {Datatype - String} into "20180626" {Datatype - String

 

 

By Using TalendDate.parseDate it throws Unparsable Date error  !!

Labels (2)
1 Solution

Accepted Solutions
Jesperrekuh
Specialist
Specialist

Sorry, copy pasted wrong code.

System.out.println(TalendDate.parseDate("EEE, dd MMM yyyy HH:mm:ss Z","Thu, 21 Jun 2018 12:22:00 -0500"));

System.out.println(TalendDate.parseDate("EEE MMM dd HH:mm:ss Z yyyy","Wed Jun 27 15:57:11 IST 2018"));

View solution in original post

4 Replies
Jesperrekuh
Specialist
Specialist

"Tue, 26 Jun 2018 09:00:15 -0500" use this format : "E, dd MMM yyyy HH:mm:ss XXX"
"Wed Jun 27 15:57:11 IST 2018" use this format : "E MMM dd HH:mm:ss Z yyyy"
Anonymous
Not applicable
Author

@Dijke

 

I'm getting this error

Exception in component tFileCopy_6 (FetchFromGmail)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Thu, 21 Jun 2018 09:00:31 -0500"
at routines.TalendDate.parseDate(TalendDate.java:898)
at routines.TalendDate.parseDate(TalendDate.java:842)
at delwarejob.fetchfromgmail_0_1.FetchFromGmail.tPOP_5Process(FetchFromGmail.java:1506)
at delwarejob.fetchfromgmail_0_1.FetchFromGmail.runJobInTOS(FetchFromGmail.java:2185)
at delwarejob.fetchfromgmail_0_1.FetchFromGmail.main(FetchFromGmail.java:1807)
Caused by: java.text.ParseException: Unparseable date: "Thu, 21 Jun 2018 09:00:31 -0500"
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:884)
... 4 more

Jesperrekuh
Specialist
Specialist

Sorry, copy pasted wrong code.

System.out.println(TalendDate.parseDate("EEE, dd MMM yyyy HH:mm:ss Z","Thu, 21 Jun 2018 12:22:00 -0500"));

System.out.println(TalendDate.parseDate("EEE MMM dd HH:mm:ss Z yyyy","Wed Jun 27 15:57:11 IST 2018"));
Anonymous
Not applicable
Author

Thanks @Dijke

[Solved]

Works very fine to me