CURRENT_DATE

CURRENT_DATE returns the current date.

This function returns the same value if it is executed more than once in a single statement, which means that the value is fixed, even if there is a long delay between fetching rows in a cursor.

Syntax

CURRENT_DATE

or, alternately

CURRENT DATE

Results

A  DATE value.

Examples

The following query finds all players older that 33 years (as of Nov. 9, 2015) on the Cards baseball team:

splice> SELECT displayName, birthDate
   FROM Players
   WHERE (BirthDate+(33 * 365.25)) <= CURRENT_DATE AND Team='Cards';
DISPLAYNAME             |BIRTHDATE
-----------------------------------
Yuri Milleton           |1982-07-13
Jonathan Pearlman       |1982-05-28
David Janssen           |1979-08-10
Jason Larrimore         |1978-10-23
Tam Croonster           |1980-12-19
Alex Wister             |1981-08-30
Robert Cohen            |1975-09-05
Mitch Brandon           |1980-06-06

8 rows selected

See Also