topic [resolved] HELP - GET SUBSTRING OF DATE in Talend Studio

[resolved] HELP - GET SUBSTRING OF DATE

Anonymous — Mon, 19 Oct 2015 14:28:27 GMT

Dear all,

I have a date format which look like that: 2015-10-25T00:00:00+02:00
May somebody tell me how get only 2015-10-25 in my XMLMap
I precise in tXMLMap, because i get this date format with component tXMLMap
And i try to put string type, but i get Unparseable date error

Thanks,

Re: [resolved] HELP - GET SUBSTRING OF DATE

Anonymous — Mon, 19 Oct 2015 16:59:55 GMT

Dear all,
I tried to parse it by doing :
TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss Z",2015-10-25T00:00:00+02:00 )
or
TalendDate.formatDate("yyyy-MM-dd'T'HH:mm:ss Z",2015-10-25T00:00:00+02:00 )

But it does not work, help me please

Re: [resolved] HELP - GET SUBSTRING OF DATE

Anonymous — Tue, 20 Oct 2015 09:03:23 GMT

hi IDEMBELE,
you say that you've got a date format & try to put String type.
could not read this data directly as a String ? When you manage data in Talend, use Date type only when you need java methods about Date.
otherwize only use String.
And use String method like substring

hope it help
regards
laurent

Re: [resolved] HELP - GET SUBSTRING OF DATE

Anonymous — Tue, 20 Oct 2015 09:43:49 GMT

Hi kzone,
No it is not possible to read it as a string, i have already tried it.
And i get error, so i am obliged to format it first in string and get sub-string
Thanks,

Re: [resolved] HELP - GET SUBSTRING OF DATE

Anonymous — Tue, 20 Oct 2015 17:19:45 GMT

Hi kzone,
You are right, it is ok to set string format.
Thank you