Default date

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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?

    active DATE DEFAULT ?????,
    PRIMARY KEY (id),

Thanks in advance

Re: Default date

Rob wrote:
Quoted text here. Click to load it
Why not vonvert the column to a timestamp? This way it will always hold
the current date (and time) if you modify the record.


A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Re: Default date

Rob wrote:
Quoted text here. Click to load it


"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, TIMESTAMP Properties as of MySQL 4.1."

So this means that you can't do what you describe on a field with a DATE
  datatype.  You must use TIMESTAMP as the datatype.

Bill K.

Site Timeline