Oracle Connector Import Converts Date into Timestamp

devsonali · Post by **devsonali** » Tue Oct 16, 2012 8:45 am

Hello All

I am trying to import metadata via Oracle Connector import by connecting to Oracle DB . One of the column in Oracle shows the datatype as Date 10 (as it should be ) but once I import the metadata , the same field shows up as timestamp (no length defined )

I was wondering why this would happen and how do I make it a date datatype so that I don t have to append the time and load the table as timestamp.

Please advice

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Oct 16, 2012 3:11 pm

All DATE data types in Oracle have a time component.

lstsaur · Post by **lstsaur** » Tue Oct 16, 2012 6:28 pm

And DATE data types store the data in Oracle's internal foramts.

oracledba · Post by **oracledba** » Wed Oct 17, 2012 3:02 pm

if the oracle database has it as date then simply change it in the metadata definitions pull down for SQL Type and change to date. You have to make sure to use the data type that the source oracle database says it is.