topic Re: Date/Time conversions in TMap????? in Talend Studio

Date/Time conversions in TMap?????

ankit7359 — Fri, 30 Nov 2018 10:40:11 GMT

Hi,

I am trying to convert String(Date in String) to Date.

and the vice - versa.

Also when i am using TalendDate functions/Routines in Tmap - TalendDate.formatDate() for conversion of Date to String... i m not able to get it ....

While the same thing happens if i use TalendDate.parseDate() for conversion of String to Date...

The input date as String is "02/01/1996 05:09:00"

trowgenerator----> tmap------>tlogrow..

Pls help...

Thanks in advance,

Ankit

manodwhb — Fri, 30 Nov 2018 10:52:49 GMT

@ankit7359,when you convert string to date the below expressions will work that you should specify the correct date format.

stringtodate

TalendDate.parseDate("dd/MM/yyyy HH:mm:ss", row3.newColumn)

date to sting

TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", row3.col)

ankit7359 — Fri, 30 Nov 2018 11:48:53 GMT

Thanks for your response...

What if you have a use - case that String Date should be converted to String Date format...??

I know it quite silly, but can it be possible.. for example.

"02/01/1996" -> "1996/02/01"

Also,on the other post of Tmap understanding issue.....

i was able to get some idea on Inner Join and its reject.. But do you have any other link for Match model and other properties for Tmap...

I wasnt able to get clear understanding on those properties.

Can you pls help me in this regard...

Thanks,

Ankit

SachinD — Fri, 30 Nov 2018 12:17:45 GMT

convert date to string

TalendDate.formatDate("yyyy-MM-dd",row1.DATE)

convert string to date

TalendDate.parseDate( "yyyy-MM-dd",row1.DATE)

manodwhb — Fri, 30 Nov 2018 13:08:13 GMT

@ankit7359,use the below way.that which will convert the date format.

TalendDate.parseDate("yyyy/MM/dd",TalendDate.formatDate("dd/MM/yyyy",row3.newColumn))

manodwhb — Mon, 03 Dec 2018 07:39:03 GMT

@ankit7359,still do you have issue? if not please,please mark a solution,so that it will be helpful to others.