 |
 |
Archives of the TeradataForum
Message Posted: Wed, 30 Jul 2003 @ 17:58:10 GMT
| Subj: | | Re: Create Table -> date default |
| |
| From: | | Geoffrey Rommel |
| | activity_dt DATE NOT NULL FORMAT 'mm/dd/yyyy' DEFAULT -18989899, | |
| | The programmer has assured us that the default would be 01/01/0001. But it is not, the Unix timestamp above gives a date in the
1969's. | |
The programmer is right. The date field in Teradata is not a Unix timestamp, but a different scheme altogether; consult the
manuals for details. The default shown above is correct, but if it makes you uneasy, you could do this instead:
activity_dt DATE NOT NULL FORMAT 'mm/dd/yyyy' DEFAULT DATE '0001-01-01'
| |
