Alter table and modify column (curent_date)

[bepese]

Hi;

I have an sql database with a table called: "stardate" with default value set up with "dat" I want to modify this column default value to current date (server side) I'm trying this:

Alter table my_table 
Modify startdate DATE  DEFAULT CURRENT_TIMESTAMP;

with this error: Error Code: 1067. Invalid default value for 'startdate'

I'm working with workbench and last sql server on local. And i'm tourning crazy!! any idea?

Thanks in advance!!

[code739]

use this instead.... replace date to timestamp...; hope it will help =)

ALTER TABLE table_name
 MODIFY COLUMN  column_name TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

[bepese]

well, it works, but, another question: doing this are we forcing to introduce current DATE to the user or "forcing" our server to "stamp" current date?

Thanks in advance again!

[code739]

forcing the server to stamp current date