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