Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 15 Sep 2002 @ 12:44:03 GMT


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


Subj:   Re: Decimal or time in PI
 
From:   Raghav Vaidya

Besides the hashing, the problem is also with the format. The formats for a Teradata timestamp & a DB2 timestamp vaires. At an earlier client that I worked (on V2R3) , we tried to load a DB2 tmestamp to Teradata and gave up. Even after reformatting, we could not get it to work.

At my current client, we stay away from using Timestamp because of these "problems". This means storing data that comes from a Oracle system in a different format. If the datatype from Oracle is Timestamp, we either store just the date portion or date & and a CHAR(6) time field.

I understand NCR has a fix for these in V2R5.01 (right?.)

Raghav...



     
  <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: 15 Jun 2023