CODE EXAMPLE FOR SQL

sql server alter table add column datetime default current_timestamp

ALTER TABLE <tableName> ADD <columnName> Date  DEFAULT CURRENT_TIMESTAMP