GetDate() or CURRENT_TIMESTAMP – SQLServerCentral Forums
I think Microsoft prefers getdate(). CREATE TABLE #test (RowID INT IDENTITY, MyDate DATETIME DEFAULT (CURRENT_TIMESTAMP)); SELECT definition FROM tempdb.sys.default_constraints WHERE parent_object_id = object_id('tempdb..#test'); returns: ...