how to add column date in sql code example

Example: add colum date in sql

ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;