This article is tagged with:
Sql set default value datetime now
and mysql
sql set default value datetime now
ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn