topic [resolved] Any way to specify this datetime format from schema editor ?? in Talend Studio

[resolved] Any way to specify this datetime format from schema editor ??

vladika — Sat, 16 Nov 2024 13:01:01 GMT

This is what kind of datetime format I have inside xml file:
12/3/2010 4:02:24 PM
Do I need to import this field as a string and then extract the date, or can I just specify a datetime format inside the schema editor in tFileInputXML ??
From the drop down menu (CTRL+SPACE) in date pattern column of schema editor I don't see the possibility to specify this type of format. The trouble is that days, months and hours can be either one or two numbers (no leading zeros).
Thx.

Re: [resolved] Any way to specify this datetime format from schema editor ??

Anonymous — Tue, 29 Mar 2011 04:26:43 GMT

Hi
Specify the datetime format inside the schema in tFileInputXML as:
"dd/MM/yyyy hh:mm:ss aa"
or
Extract it as a string and then convert this string to Date on tMap or other component, for example:
TalendDate.parseDateLocale("dd/MM/yyyy hh:mm:ss aa", yourInputColumn,"en")
Best regards
Shong

Re: [resolved] Any way to specify this datetime format from schema editor ??

alevy — Wed, 30 Mar 2011 02:50:11 GMT

The drop-down options for date pattern in the schema editor are just common suggestions. You can type any pattern you want built from the different date-part symbols or even use a variable.

Re: [resolved] Any way to specify this datetime format from schema editor ??

vladika — Wed, 30 Mar 2011 15:30:12 GMT

It works. Thanx guys.

Re: [resolved] Any way to specify this datetime format from schema editor ??

Anonymous — Mon, 27 Jun 2016 09:30:38 GMT

Hi,
I specified the datetime format inside the schema of tFileInputdelimited as:
"MM/dd/yyyy HH:mm:ss aa" so that I can load the data "5/17/2016 12:00:00 AM" into DB2.
But I couldn't load the exact format.
I come across "Unparseable date" error and the date loaded into the db is "5/17/2016 12:00:00"
Can you please help to load this date format into DB2.
Thanks in advance.