Returns the current date time based on the local server time.
This may be used as a default value in a table for automatically inserting the date and time of an insert. You would set the default value for the column as DATE().
This command has now been removed and cannot be used. You should use the GETDATE() function from SQL Server instead.
select DATE(); Returns: 4/28/2007 2:58:36 PM