w3resource

PostgreSQL CURRENT_DATE() function

CURRENT_DATE() function

This function is used to return the current date.

Syntax:

current_date()

Return Type: date.

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL CURRENT_DATE() function

Pictorial presentation of PostgreSQL CURRENT_DATE() function

Example: PostgreSQL CURRENT_DATE() function

Code:

SELECT current_date;

Sample Output: 

    date
------------
 2015-01-14
(1 row)

N.B. - The outputs may change with the current date.

Previous: CLOCK_TIMESTAMP function
Next: CURRENT_TIME function