Alter Column
suggest changeALTER 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.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents