[resolved] Date formatting problem XML --> Oracle

One Star

[resolved] Date formatting problem XML --> Oracle

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
Seven Stars

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

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.
One Star

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

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