Posted onFebruary 9, 2011 by Josephine add auto datetime field alter table table_name add requestdatetime int, myDate datetime DEFAULT(getdate())