Date and Time in a SQL Statement (DateTime)

To get the date and time for a datetime value in SQL Server, use the GetDate method.  It will return the current system date and time in the SQL Server standard internal format for datetime values.

This is a pretty useful function if you need to know the date/time in a select statement or a where clause.

SELECT GETDATE()

GO

Here is the result set:
————————-
April 10 2006   11:39    AM

(1 row(s) affected)