topic Re: Date conversion "dd/MM/yy" in Talend Studio

Date conversion "dd/MM/yy"

Vivi2 — Thu, 18 Aug 2022 07:08:08 GMT

Hello,

while I am trying to integrate date with format "dd/mm/YY" like 24/05/30 (from file) I have 24/05/2030 in postgresql database. It should be 24/05/1930

Note that in tmap I am doing conversion :

row1.Date_de_Naissance == null || ? null:TalendDate.parseDate("dd/MM/yy",row1.Date_de_Naissance)

How to do please?

Thanks

Re: Date conversion "dd/MM/yy"

Anonymous — Thu, 18 Aug 2022 09:00:00 GMT

The function thinks it is the current century, try this expresssion.

row1.Date_de_Naissance == null || ? null:TalendDate.parseDate("dd/MM/yyyy",row1.Date_de_Naissance.substring(0,row1.Date_de_Naissance.lastIndexOf("/")+1)+"19"+row1.Date_de_Naissance.substring(row1.Date_de_Naissance.lastIndexOf("/")+1))

and set the date pattern as "dd/MM/yyyy" of Date_de_Naiss column in out1 table.

Regards

Shong

Re: Date conversion "dd/MM/yy"

Vivi2 — Thu, 18 Aug 2022 09:59:37 GMT

Thanks for your reply .

But how if in the same file i have 15/11/19. It should be 15/11/2019 not 15/11/1919.

Re: Date conversion "dd/MM/yy"

Anonymous — Thu, 18 Aug 2022 15:46:42 GMT

What's the logic here? If yy is greater than the current year(22), it is 19yy, otherwise, it should be 20yy?