topic String to Date convert in Talend Studio

String to Date convert

DrGenious — Wed, 22 Jan 2020 13:38:35 GMT

Hi,

I have a column with strings like "2.02E+13". How can I make them Date type?

Thanks a lot.

Re: String to Date convert

TRF — Thu, 23 Jan 2020 12:32:20 GMT

2.03E+13 is equal to 20 200 000 000 000 which doesn't represent a valid date, so...
Any way, you can convert your input to a string using String.format("%.0f", row1.yourValue) then use TalendDate.formatDate to convert the result to a date

Re: String to Date convert

DrGenious — Thu, 23 Jan 2020 13:15:56 GMT

The solution I found is to convert my string to bigdecimal ,after to plainString and then parse it into .parseDate. But I will try also you solution. Thanks a lot for your help.