The CURRENT_TIMESTAMP function returns this value. 4> 5> CREATE TABLE T ( 6> int1 int, 7> bit1 bit NOT NULL DEFAULT 0, 8> rvr1 timestamp, 9> usr1 nvarchar(128) DEFAULT USER, 10> createtime datetime DEFAULT CURRENT_TIMESTAMP 11> ) 12> GO 1> 2> drop table t; 3>