Archives of the TeradataForum
Message Posted: Sun, 15 Sep 2002 @ 12:44:03 GMT
| 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...
| 
