Import Data into Oracle Table with Date

by Nov 4, 2012

Hey Guys,

I’m trying to import some data that includes a date into a table on Oracle using the import tool. I exported this data from a DB2 table using the same tool, but I’m having an issue with the date when I try to push it to Oracle. The date values in the exported data are formatted as [2013/04/30] for example, and I have a matching date mask on the import side. When I preview the insert statements I get an ‘unparseable date: “2013/04/30″‘ warning, and the dates are absent from the insert statement. Can you point me in the right direction?

Thanks for your help


Niels Gron over 10 years ago
Oracle has a DATE data type which is essentially a DATETIME data type. Oracle only has a DATE data type and no other DATETIME data type. When you Import into Oracle, make sure to make the “Date/Time” format equal to the format of your date, since that is the value ADS will use when importing into the DATE data type for Oracle.