topic Re: Changing date type in Talend Studio

Changing date type

Anonymous — Sat, 05 Oct 2019 23:50:15 GMT

Hello All

Can anyone help for this below requirement , am getting unpareble date when am passing through tMap

I do i have a date format in MM/dd/yyyy and i need to change that date format into yyyy-MM-dd

example

10/05/2019 to 2019-10-05

Thanks

Manish

Anonymous — Sun, 06 Oct 2019 00:01:06 GMT

Example

Input

05/10/2019

and in

output

2019-10-05

i used function but it did not worked to me

TalendDate.parseDate("MM/dd/yyyy",TalendDate.formatDate("yyyy-dd-MM" row1.Date ))

Sujay1 — Sun, 06 Oct 2019 13:27:08 GMT

Hi @ksingh try like this it worked for me. I tested and it worked for me.

TalendDate.formatDate( "yyyy-MM-dd",row2.dt)

Output is like below:

I added other date formats just in case if someone needs it.Happy to help.