Functions

CURRENT_DATE

The CURRENT_DATE function returns the current date from the system's time-of-day clock.

The function is processed once at the beginning of execution of the SQL statement. A new value is not obtained with each reference or with each fetched row.

Syntax

CURRENT_DATE

Example

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

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

Top