Archives of the TeradataForum

Message Posted: Wed, 30 Jul 2003 @ 17:25:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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?

Thanks.

	<Prev	Next>		<<First	<Prev	Next>	Last>>