This article is tagged with:
Sql create table with datetime automatically
and mysql
sql create table with datetime automatically
CREATE TABLE myTable ( col1 int, createdDate datetime DEFAULT(getdate()), updatedDate datetime DEFAULT(getdate()) )