CODEWITHSUNDEEP
oracle-databasekettlenetezza
user1251973
user1251973

Reputation: 339

Netezza Time datatype to Oracle

How to convert Netezza Time datatype to Oracle. We are migrating from Netezza to Oracle. Currently in netezza there is column which is having dataype time. How can I migrate the same to Oracle. I am using kettle as ETL tool for the same.

Upvotes: 1

Views: 823

Answers (1)

mucio
mucio

Reputation: 7119

I would go for the TIMESTAMP datatype in Oracle. If you have also a date column in Netezza you can combine it with the time column to store in Oracle a full TIMESTAMP.

Depending on your use case this solution can simplify or complicate your or the fron-end developers' life :)

Edit:

My preference would be to keep two separated columns, one with just the date and the second one for the time, but for the Oracle TIMESTAMP you will need to add the date:

Neteza table

Date_column | Time_column
2013-10-23  | 15:11

Oracle table

Date_column | Time_column (TIMESTAMP)
2013-10-23  | 2013-10-23 15:11

To keep the Date_column will allow the application using that column to work without changes, who is using the time_column will need to do some work (maybe just in terms of formatting)

Upvotes: 2

Related Questions