how to use current date in mysql to alter default value code example

Example: set default today mysql

ALTER TABLE table
ADD column DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;