topic Re: datetime string to date in Talend Studio

datetime string to date

MattE — Wed, 12 May 2021 15:17:39 GMT

Hi,

I've got a column in a database which is a string like this

Tue May 11 2021 00:15:17 GMT+0000 (UTC)

and i want to turn this into a date like

2021-05-11 00:15:17

Is there any prebuilt function to do this?

Thanks

gjeremy1617088143 — Wed, 12 May 2021 15:28:43 GMT

Hi,

TalendDate.parseDate()

MattE — Wed, 12 May 2021 15:30:01 GMT

I've tried them all but can't find one which doesn't throw an error converting

Tue May 11 2021 00:15:17 GMT+0000 (UTC) into 2021-05-11 00:15:17

gjeremy1617088143 — Wed, 12 May 2021 16:53:40 GMT

You have to find the good pattern :

https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

MattE — Thu, 13 May 2021 15:02:57 GMT

Thanks @guenneguez jeremy you set me on the right path. In the end i had to get rid of the text at the end and use the right pattern

TalendDate.parseDate("E MMM dd yyyy HH:mm:ss",redemption.transaction_date.substring(0, redemption_rakuten.transaction_date.indexOf("GMT")).trim())

gjeremy1617088143 — Thu, 13 May 2021 16:13:56 GMT

Glad you find by yourself