SQL ALTER TABLE Alter Column
Example
ALTER TABLE Employees
ALTER COLUMN StartingDate DATETIME NOT NULL DEFAULT (GETDATE())
This query will alter the column datatype of StartingDate and change it from simple date to datetime and set default to current date.
