DATE()

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().

Remarks

This command is not supported in SQL Server and has been deprecated in VistaDB.

This command has now been removed and cannot be used. You should use the GETDATE() function from SQL Server instead.

Example

select DATE();

Returns:

4/28/2007 2:58:36 PM