Date formats in Oracle

From Fmepedia

Q) I can't seem to get Date information to load into an Oracle Date type field? What format does it need to be in?

A) Oracle expects DATE values in the format YYYYMMDDHHMMSS even though when you display a date field from an Oracle table it will show with ":"s in the time. So to write dates to an Oracle date field you can use the TIMESTAMPER transformer to get the date into the correct format. Set the Time Stamp Format String to be ^Y^m^d^H^M^S and your date fields should load correctly.