how to add column value as date in sql code example

Example: add colum date in sql

ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;