VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Functions / Date and Time Functions / DATE *deprecated*
In This Topic
    DATE *deprecated*
    In This Topic

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


    select DATE();
    4/28/2007 2:58:36 PM

    See Also