The CURRENT_TIMESTAMP function returns the current timestamp from the server's time-of-day clock. The function is processed once at the beginning of the execution of the SQL statement. A new value is not obtained with each reference or with each fetched row. In a client-server or Omnidex Grid application, the timestamp returned is from the individual server processing the query.

This function returns an ANSI DATETIME datatype.

CURRENT_TIMESTAMP

> select current_timestamp from $omnidex;

CURRENT_TIMESTAMP
----------------------
2010-07-28 16:23:19.00

See also: