VistaDB 5
GETUTCDATE

GETUTCDATE

Returns the current UTC date and time (Coordinated Universal Time or Greenwich Mean Time) using the internal format for datetime values. The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer. If the time zone setting on the machine is wrong their will return incorrect results.

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

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

Example

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

See Also