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