topic Re: Convert string to date in Talend Studio

Convert string to date

EnriqueLDE — Thu, 29 Apr 2021 13:43:35 GMT

Hi,

I have my string input 01012021 and i need to convert it to date output 01/01/2021 in my tmap. How can i do that? Thank you!

Regards,

Enrique

Re: Convert string to date

gjeremy1617088143 — Thu, 29 Apr 2021 13:47:53 GMT

Hi,

TalendDate.parseDate("ddMMyyyy",here your input string)

Send me Love and Kudos

Re: Convert string to date

EnriqueLDE — Thu, 29 Apr 2021 13:53:33 GMT

Thank you!

Re: Convert string to date

gjeremy1617088143 — Thu, 29 Apr 2021 14:21:00 GMT

you'r welcome , in your output schema set a pattern for your date : "dd/MM/yyyy", if you want the date as you mention.

Re: Convert string to date

EnriqueLDE — Thu, 29 Apr 2021 17:25:37 GMT

I get an error because there is a null value in my input. How do you set a condition to ignore the value when it's null or do TalendDate.parseDate("ddMMyyyy",input) when it is not null? Thank you!

Re: Convert string to date

gjeremy1617088143 — Thu, 29 Apr 2021 18:06:46 GMT

You can write (your input) != null

in the expression filter of the tMap output

Re: Convert string to date

CSharma1636705679 — Tue, 07 Dec 2021 07:59:33 GMT

Hey Thanks a lot, but I am having one issue I got "ERROR: timestamp out of range". my string is a timestamp I want to make it as a timestamp (Date)

my timestamp is - "1631898440"

please help 😞