topic Re: [resolved] Date formatting problem XML --> Oracle in Talend Studio

[resolved] Date formatting problem XML --> Oracle

Anonymous — Wed, 22 Aug 2012 20:45:51 GMT

I am trying to convert XML into Oracle. The date formats are not coming out correctly and I can't figure out what I have wrong. It has every date converting to Jan. Attached are screen prints to show the input and the output, debug and tMap

Re: [resolved] Date formatting problem XML --> Oracle

alevy — Thu, 23 Aug 2012 08:37:03 GMT

It's because you've defined the Date Patterns in tFileInputXML as "yyyy-mm-dd-hh:mm" when they should be "yyyy-MM-dd-hh:mm". mm is minutes, MM is months.
You should also check your hours setting: hh is 12-hour time (01-12), HH is 00-23.

Re: [resolved] Date formatting problem XML --> Oracle

Anonymous — Thu, 23 Aug 2012 12:45:22 GMT

Thanks! I'm still getting used to Talend and missed the date formatting error.