CURRENT_DATE

Returns the date (date-type value) on which the current transaction started.

Behavior Type

Stable

Syntax

CURRENT_DATE()

You can call this function without parentheses.

Examples

SELECT CURRENT_DATE;
  ?column?
------------
 2010-09-23
(1 row)