Archives of the TeradataForum
Message Posted: Wed, 12 Nov 2008 @ 11:24:55 GMT
<-- Anonymously Posted: Wed, 12 Nov 2008 16:45 -->
We are facing an issue while modifying a table via ALTER statement.
I added two columns (defined as timestamp(6)) via ALTER statement on SQL Assistant.
Alter table dgw.entry_service_person ADD creation_date_time TIMESTAMP(6) ,ADD last_update_date_time TIMESTAMP(6);
when I do show table I see definition of column as follows:
creation_date_time CHAR(23), last_update_date_time CHAR(23)
however, when one of my colleague issued same statement on his system via SQL Assistant. following was added to table definition.
creation_date_time TIMESTAMP(6), last_update_date_time TIMESTAMP(6))
which was correct and expected.
I am puzzled about why on my system this is not happenning. Could you please throw light on this?
we are on teradata VERSION 12.00.01.20, RELEASE 12.00.01.21
Thanks in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|