Posted by Rob on 05/11/05 18:03

Hello all

I have a field (called active) of type DATE and I want to add a default
value. The default value must be the current date. Is this possible to do
this in the table create statement?

CREATE TABLE mytable
(
id INTEGER NOT NULL AUTO_INCREMENT,
active DATE DEFAULT ?????,
PRIMARY KEY (id),
)

Thanks in advance
Roger

[Back to original message]