SELECT GETDATE() AS TODAY /* TODAY ----------------------- 2008-04-15 22:47:59.013 (1 row(s) affected) */