Re: Datetime Defaults
Troy
Try
time_stamp DATETIME YEAR TO SECOND CURRENT YEAR TO SECOND NOT NULL;
HTH
Sujit
______________________________ Reply Separator _________________________________
Subject: Datetime Defaults
Author: "Troy Peterson" <tp096255@gte.net> at internet
Date: 8/22/98 3:00 PM
In dbaccess I get a "591: Invalid default value for column/variable
(time_stamp)" when I try to create a field in my table as follows:
time_stamp DATETIME YEAR TO SECOND DEFAULT CURRENT NOT NULL
Why is it balking at the use of "CURRENT"? I tried "TODAY" but it didn't
work either.
Thanks for any light anyone can shed on this.