 |
 |
Archives of the TeradataForum
Message Posted: Wed, 26 Mar 2003 @ 22:53:56 GMT
| 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!
| |
