i believe you'll need to use a timestamp column, which will set to the
current date/time at each insert/update. I don't think you can set the
date default to a function.
You are also using a reserved word Date for your column name without
escaping it, i.e. `Date`, also you have two modify's in
http://www.mysql.com/doc/en/CREATE_TABLE.html
A DEFAULT value has to be a constant, it cannot be a function or an
expression.
...
Default values must be constants. 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
Mike Morton [EMAIL PROTECTED] wrote:
I am trying to change a column specification, a date column, so that the
default value is the current date. Is this possible? I just get an error
on the change query:
alter table Hits modify modify Date date NOT NULL default CURDATE();
ERROR 1064:
Mikael:
Thanks - I must have missed that in the create table docs - I did look there
first - honest!
And you are correct - in that the timestamp is too much precision, and
unfortunately due to the thousands of distributed apps that access this DB,
I cannot modify all the queries - oh well,
From: Mikael Fridh [mailto:[EMAIL PROTECTED]
or read about the TIMESTAMP type, but I guess that's too much
precision since you only wanted the date, not the time.
http://www.mysql.com/doc/en/DATETIME.html
It's only too much precision when you're selecting the whole field. You can simply