Date Functions MSSQL Tutorial

4> Select GETDATE()
5> GO
-----------------------
2008-08-12 20:24:17.060
(1 rows affected)