SQL 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

top

Example

select company,

current_date

from customers
where company='dynamic'

...

Dynamic Information Systems Corporation, 2003-01-24

top