From: Xah Lee
Date: April 6 1999 1:42pm
Subject: default DATE to now()?
List-Archive: http://lists.mysql.com/mysql/1460
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

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