topic Re: Convert string to date into a tMap in Talend Studio

Convert string to date into a tMap

_AnonymousUser — Wed, 13 Apr 2016 17:04:01 GMT

Hello,
I would like to convert the following string :
2016 Apr 12 05:30:35
into date to import it into a tOracleOutput from a tMap in the following format :
12/04/2016 05:30:35
but I encounter the error
Type mismatch cannot convert from string to date.
I tried different ways : expression with TalendDate.parseDate, date pattern
Any help would be nice

Re: Convert string to date into a tMap

Anonymous — Thu, 14 Apr 2016 08:57:54 GMT

Hi,
Could you please show us your tMap editor screenshot?
Best regards
Sabrina

Re: Convert string to date into a tMap

_AnonymousUser — Thu, 14 Apr 2016 09:15:37 GMT

Hi
Thanks for your reply, I did it.
So what I did is :
In expression filter on the right panel of the tMap I replaced row3.TIMESTAMP
by TalendDate.parseDate("yyyy MMM dd HH:mm:ss",row3.TIMESTAMP)
AND
on the table below I set the date pattern I would like to have :
"dd/MM/yyyy HH:mm:ss"
That's all

Re: Convert string to date into a tMap

Anonymous — Thu, 14 Apr 2016 11:52:21 GMT

Hi,
Have you tried to use the built-in function TalendDate.parseDateLocale() to convert the string(text) data to a Date?
The expression should be: TalendDate.parseDateLocale("yyyy MMM dd HH:mm:ss", row3.TIMESTAMP ,"EN")
Best regards
Sabrina

Re: Convert string to date into a tMap

_AnonymousUser — Thu, 14 Apr 2016 13:05:19 GMT

Hi,
No, what is the difference with what I did ?
Regards

Re: Convert string to date into a tMap

Anonymous — Fri, 15 Apr 2016 04:15:31 GMT

Hi,
Is it working well for you when your use the built-in function TalendDate.parseDateLocale()?
Best regards
Sabrina

Re: Convert string to date into a tMap

Anonymous — Fri, 15 Apr 2016 07:44:13 GMT

RichardG:
Check this out for a better understanding for date handling : http://www.talendbyexample.com/talend-date-handling.html
regards john

Re: Convert string to date into a tMap

Anonymous — Fri, 15 Apr 2016 09:24:46 GMT

Another strange idea
Try to rearrange your Fields from the input schema.
It sound ridiculous
But i had some Job's here with an Date Problem or an Lookup one which i only rearrange the the Fields from the input schema.
In this point Talend is a little bit buggy
regards john

Re: Convert string to date into a tMap

Anonymous — Mon, 18 Apr 2016 11:16:32 GMT

Hi,

Try to rearrange your Fields from the input schema.

Are you using studio 6.1.1? What does the expected result look like? Could you please show us the problem you are getting?
Best regards
Sabrina