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.

CURRENT_DATE

> 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: