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!!