topic Re: Format of Date in Talend Studio

Format of Date

Subash1 — Sat, 16 Nov 2024 03:29:28 GMT

Hello all.

I am using tftpfileproperty in one of my job. It has one schema in it called mtime_string which is the date in string format like : "Tue Jan 14 13:30:09 IST 2020". Now i am using a tmap and my aim is to convert this "Tue Jan 14 13:30:09 IST 2020" into a date format of "yyyyMMdd" only.

How to do it ...can anyone please suggest..?

Many Many thanks

Re: Format of Date

TRF — Thu, 23 Jan 2020 09:14:47 GMT

Try this:

TalendDate.formatDate("yyyyMMdd", TalendDate.parseDate("EEE MMM dd HH:mm:ss z yyyy", row1yourDateField))

This should work.

Re: Format of Date

Subash1 — Fri, 24 Jan 2020 02:52:01 GMT

Hii TRF,

Thanks so much.It worked for me