Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
soujanyam
Contributor
Contributor

[resolved] cannot convert string to date in tMap

Hi everyone.
I've the csv file in which one column has date (which is defined as Number in csv file) but in tFileInpuDelimited it read as string in which some of the vales are like 20140424 and some are like 2014-04-25 in the same column.I've to parse this data into output component( tOracleOutput)as date column.So I tried to convert the string to date by using 
TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",row1.column1)) and changed the output column as date with format yyyy-MM-dd.
Then I'm getting error as 
Unparseable date: "20140424".
How could I parse this into output component?
Any help would be greatly appreciated.
Thank you in advance.
Labels (3)
32 Replies
Anonymous
Not applicable

Hi,
Have you tried to set the date pattern "MM/dd/yyyy" to see if it works?
Best regards
Sabrina
Anonymous
Not applicable

Hi,
Yes i have tried this in many more jobs & it gives expected outcome.
even before this i have converted Dates into milliseconds.. & in MM/DD/YYYY format as well.
I got one SQL query which converts milliseconds into Date in given format. Please look into that..
Select To_Date('01/01/1970 00:00:00', 'DD/MM/YYYY HH24:MI 0683p000009M9p6.pngS') +( 1425148200000 / 1000 / 60 / 60 / 24) FROM Dual;
O/P - 28-FEB-15 (Oracle Format)
_AnonymousUser
Specialist III
Specialist III

Hi Umesh/All,
i have a scenario like this 
input string 01/29/13 we need out put like 01/29/2013 but i am getting 01/29/0013
i have used below function 
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco} span.s1 {color: #3933ff}
TalendDate.parseDate("mm/dd/yyyy",row1.Date_received) 
can any one give the solution.
Regards
Bajivali