Default date in mysql?

Question

how can I correct this query, I need to change a column to start if the value is null

alter table PROJECT_ASSIGNMENT modify date_start date default '01/01/2000 00:00:00'; ???

regards

Answer 1

ALTER TABLE PROJECT_ASSIGNMENT MODIFY date_start DATE DEFAULT '2000-01-01';