how to add a date column in sql code example

Example: add colum date in sql

ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;