|
|
Archives of the TeradataForum
Message Posted: Mon, 24 Feb 2003 @ 18:11:22 GMT
Subj: | | Queryman and ODBC changed TIMESTAMP to CHAR(23) |
|
From: | | John Adams |
And boy, was I surprised!
Due to no existing CD-ROM for our modelling software, I get to apply a lot of "models" by hand. Sometimes, I cut and paste in Queryman
and sometimes I run scripts through bteq, and I'd never noticed any difference in the results until today, when this:
create multiset table db.tbl (
CREATED TIMESTAMP not null,
showed up as this:
create multiset table db.tbl (
CREATED CHAR(23) not null,
So, what's the deal? I'm guessing it's the ODBC driver (I'm using 2.08.00.00) and not Queryman (5.1.0) causing my headache.
Thanks,
John A
| |