topic Re: date format 1 JAN 2018 To 1-01-2018 in Talend Studio

date format 1 JAN 2018 To 1-01-2018

Anonymous — Mon, 10 Sep 2018 11:49:12 GMT

hello,

Is there any way to convert date 1 Jan 2018 to {dd-MM-yyyy 01-01-2018 }??

or how can we handle it.

Re: date format 1 JAN 2018 To 1-01-2018

TRF — Mon, 10 Sep 2018 12:07:03 GMT

Have a look to Talend date routines

Re: date format 1 JAN 2018 To 1-01-2018

Jesperrekuh — Mon, 10 Sep 2018 13:00:38 GMT

// when its a String type
TalendDate.parseDate("d MMM yyyy", row1.YourDateAsStringType )
// You first need to convert it
// then when its a Date type
TalendDate.formatDate("dd-MM-yyyy", row1.YourDateAsDateType )

Re: date format 1 JAN 2018 To 1-01-2018

ankit7359 — Mon, 10 Sep 2018 13:09:42 GMT

Hi,

you can convert date to dd-mm-yyyy, if u refer to the screenshot - Scenario-1.png, i have taken the date what you have mentioned(01 Jan 2018) in the trowgenerator and then in tmap i have converted the date format as to dd-MMM-yyyy and later printing the same onto tlogrow.

For further pls check the Scenario-1-rowgenerator,Scenario-1-tmap.

For further queries... feel free to get back

Thanks

Ankit

Scenario-1-tmap.PNG
Scenario-1-rowgenerator.PNG
Scenario-1.PNG