This is an old revision of the document!
The CURRENT_TIME function returns the current time 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 time returned is from the individual server processing the query.
This function returns an ANSI TIME datatype.
CURRENT_TIME
> select current_time from $omnidex; CURRENT_TIME ------------ 16:15:08.00
> 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: