[resolved] cannot convert string to date in tMap

[soujanyam]

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.

[Anonymous]

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

[Anonymous]

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 S') +( 1425148200000 / 1000 / 60 / 60 / 24) FROM Dual;
O/P - 28-FEB-15 (Oracle Format)

[_AnonymousUser]

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