Omnidex SQL Function: CURRENT_TIMESTAMP

Description

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.

Syntax

CURRENT_TIMESTAMP

Examples

Example 1: Column

> select current_timestamp from $omnidex;

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

Additional Resources

See also:

 
Back to top
dev/sql/functions/current_timestamp.txt ยท Last modified: 2016/06/28 22:38 (external edit)