CURRENT_DATE Function
CURRENT_DATE returns a date in the current session time zone (UTC by default) in the default format: YYYY-MM-DD.
Note
CURRENT_DATE returns the start date for the current transaction, not for the start of the current statement.
Syntax
CURRENT_DATE
Return Type
DATE
Examples
Return the current date:
select current_date; date ------------ 2008-10-01 (1 row)