String to Date Conversion

Anonymous — Sat, 16 Nov 2024 07:11:58 GMT

I have a string like "20111212120110" (string format) .

My task is to convert it into date format like 2011/12/12/ 12:01:10 (date datatype) in Talend

I tried inside tMap ,

TalendDate.parseDate("MM/dd/yyyy hh:mm:ss",row1.Date)... but showing error .

where ---> row1.Date = "20111212120110"

Regards

Subhadeep

Re: String to Date Conversion

vapukov — Tue, 27 Nov 2018 12:13:17 GMT

parseDate - convert String to Date, so and format must be not for output date (it will always the same), but format for string

in your case "yyyyddMMHHmmss" or similar because from your sample date not very clean - where months and where days