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

• Next in forum: Re: OT: why do they charge for extra db ?(Was: One database or many ?)
• Prev in forum: OT: why do they charge for extra db ?(Was: One database or many ?)
• Thread view: Add default value for date field

[Reply to this message]