topic Re: Convert String to Date format in Talend Studio

Convert String to Date format

SMahadevan1608028474 — Fri, 22 Jan 2021 14:33:04 GMT

DOB

22/12/2020 - String (10)

In output table am converting this column to Date format

TalendDate.parseDate("dd/MM/yyyy",row1.DOB)

I have changed this datatype as Date ,length 10 and changed the expecting date Pattern as" YYYYMMDD" am expecting output as 202012357 instead of 20201222.

Even I have tried with Var port method as well but still am facing the same issue.

I have observed when the time is 00:00 this issue is not occurs, attached the screenshot below,

Re: Convert String to Date format

Peter_Mitchell — Fri, 22 Jan 2021 15:42:59 GMT

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

Capital D is Day In Year. Lower d is Day In Month. You want yyyyMMdd.

Re: Convert String to Date format

SMahadevan1608028474 — Fri, 22 Jan 2021 16:11:33 GMT

Thanks for your input and it's working fine