Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 22:53:56 GMT

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

Subj:   Re: Timestamp difference
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, March 26, 2003 17:41 -->

  The columns are defined as TimeStamp data-type and the data is inserted into it by BTEQ (Windows) from a SQL Script. Value is inserted as DATE||TIME because it fails to INSERT CURRENT_TIMESTAMP.  

I suspect that you created this table via Queryman/ODBC? You may have specified timestamp, but that doesn't mean that the table was created with timestamp! Sometimes ODBC changes it (depending on what options you use). I've known people at my site who swore that they specified timestamp, but were quite surprised when they did a "SHOW TABLE XX.YY" and saw that it wasn't as they wrote it. So as Deiter says, do a show and take a look!

  <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: 27 Dec 2016