Add default value for date field

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

I think it's impossible, you have to insert the date each time you write
into your DB. Cf. MySQL Ref Manual:

"
the DEFAULT clause specifies a default value for a column. With one
exception, the default value must be a constant; it cannot be a function or
an expression. This means, for example, that you cannot set the default for
a date column to be the value of a function such as NOW() or CURRENT_DATE.
The exception is that you can specify CURRENT_TIMESTAMP as the default for a
TIMESTAMP column as of MySQL 4.1.2. See Section 11.3.1.2, "TIMESTAMP
Properties as of MySQL 4.1".

"

++

"Rob" <reply@newsgroup.nl> a écrit dans le message de news:
d5t77g$drf$1@reader10.wxs.nl...
> 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
>
>
>

On Wed, 11 May 2005 18:09:46 +0200, "VAUTHIER Christophe"
<crashbronx@wanadoo.fr> wrote:

>I think it's impossible, you have to insert the date each time you write
>into your DB. Cf. MySQL Ref Manual:
>
>"
> the DEFAULT clause specifies a default value for a column. With one
>exception, the default value must be a constant; it cannot be a function or
>an expression. This means, for example, that you cannot set the default for
>a date column to be the value of a function such as NOW() or CURRENT_DATE.
>The exception is that you can specify CURRENT_TIMESTAMP as the default for 
a
>TIMESTAMP column as of MySQL 4.1.2. See Section 11.3.1.2, "TIMESTAMP
>Properties as of MySQL 4.1".
>
>"
>
>++
>
>"Rob" <reply@newsgroup.nl> a écrit dans le message de news:
>d5t77g$drf$1@reader10.wxs.nl... 
>
No.
In your insert Query, use the pair of     active    and     curdate()