Omnidex SQL Function: CURRENT_DATE

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 in a networked environment, the time returned is from the server with the Omnidex Environment.

CURRENT_DATE

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

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