Archives of the TeradataForum
Message Posted: Wed, 16 Mar 2005 @ 12:23:55 GMT
| Subj: || || Re: Migrating Oracle date fields in Teradata |
| From: || || Aldrin, John |
Use TIMESTAMP(0) as your data type in Teradata.
If you are using the OLE-DB tool to load directly from Oracle into Teradata, it will have three columns defined for each DATE column in Oracle.
Select the one that copies the column in to the TIMESTAMP target column and then de-select the two other ones that copy the date and time portions
into separate columns.