The CURRENT_DATE function returns the current date 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 date returned is from the individual server processing the query.

This function returns an ANSI DATE datatype.

$DATA_LENGTH ( column )

Required. The name of a column, qualified by the table and database as needed.

> select current_date from $omnidex;

CURRENT_DATE
------------
  2010-07-28

> select birthdate, $compare_dates(birthdate, current_date, 'YY') age from individuals;

BIRTHDATE     AGE
------------  -----------
  1938-07-14           72
  1957-11-22           53
  1960-07-28           50
  1929-08-22           81
  1933-07-09           77
  1944-08-01           66
  2004-09-14            6

See also:

The CURRENT_DATE function returns the current date 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.

If the function is called within an application in a networked environment, the time returned is from the server with the Omnidex Environment.

This function returns an ANSI DATE datatype.

CURRENT_DATE

select company, 
current_date 
from customers 
where company='dynamic'

...
Dynamic Information Systems Corporation, 2004-03-15