topic Re: Date format issue in Talend Studio

Date format issue

RAJ6 — Tue, 28 Nov 2017 11:42:32 GMT

Hi Folks,

How to convert below date format to normal date. Kindly share your information.

INPUT

Thu Apr 30 00:00:00 UTC 2015

OUTPUT

30-03-2015

Anonymous — Tue, 28 Nov 2017 13:24:22 GMT

Hi,

You can simply use the "TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",myDate)" function.

You will get a String and can get a Date with the TalendDate.parseDate() function :

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row2.MyDate),true)

Anonymous — Tue, 28 Nov 2017 13:46:09 GMT

Hi,

Here it's the pattern

EEE MMM dd HH:mm:ss zzz yyyy

It's working for you ?

SGV