Archives of the TeradataForum
Message Posted: Wed, 30 Jul 2003 @ 17:25:05 GMT
We have a DDL for our database layout. Currently we have a column definition as follows.
activity_dt DATE NOT NULL FORMAT 'mm/dd/yyyy' DEFAULT -18989899,
The programmer has insured us that the default would be 01/01/0001. But it is not, the Unix timestamp above gives a date in the 1969's.
What is the syntax to define 01/01/0001 as the default date?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|