CODE EXAMPLE FOR SQL

sql create table with datetime automatically

CREATE TABLE myTable ( col1 int, createdDate datetime DEFAULT(getdate()), updatedDate datetime DEFAULT(getdate()) )