List:General Discussion« Previous MessageNext Message »
From:Xah Lee Date:April 6 1999 1:42pm
Subject:default DATE to now()?
View as plain text  
Is there a way to let DATE type default to current date?

for example, something like

create table table_name (sign_on_date date not null default current_date())

Of course, the above does not work.

Thanks.

Xah
xah@stripped
http://www.best.com/~xah/PageTwo_dir/more.html

Thread
default DATE to now()?Xah Lee6 Apr