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

    Returns the current system date and time using the internal format for datetime values.

    Returns
    datetime

    Where is the date computed?
    We sometimes get asked where is the date computed? On the server hosting the file, or the client? There is nothing present on the machine hosting the file to answer such a question. The only location anything ever happens within VistaDB is on the actual user machine (client).

    Since we are running in process with your application the date and times will always be based upon where the engine is actually running (local).


    Remarks

    GETDATE() may also be used as a default for a column of datetime type.


    Example

    Output: 4/28/2007 4:11:53 PM
    
    SELECT GETDATE();

    See Also