CURRENT_DATE returns a value of type DATE representing today's date.
Syntax
CURRENT_DATE
Examples
> SELECT CURRENT_DATE;
date
------------
2007-10-26
(1 row)
