[resolved] HELP - GET SUBSTRING OF DATE

[Anonymous]

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,

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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,

[Anonymous]

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