Archives of the TeradataForum
Message Posted: Wed, 04 Sep 2013 @ 22:04:40 GMT
Subj: | | Problems With Default Value For Timestamp |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, September 04, 2013 11:56 -->
Hi Everybody
I'm trying to set a default value for timestamp. I'm getting CREATE TABLE failed. 3630: Default value incompatible with type of column
record_end_dtm on the below statement.
create table edw2.t1
(record_end_dtm TIMESTAMP(6) FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)'
NOT NULL DEFAULT '2011-12-31 11:59:00.000000' )
Thanks
|