Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 16 Mar 2005 @ 12:23:55 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020