PostgreSQL current_date Function

The PostgreSQL current_date function returns the current system date in the format YYYY-MM-DD.

current_date Syntax

Here is the syntax of the PostgreSQL current_date function:

current_date -> date

Note that there are no parentheses after the function name.

Parameters

The PostgreSQL current_date function does not have any parameters.

Return value

the PostgreSQL current_date function returns the current system date in the format YYYY-MM-DD.

current_date Examples

This example shows how to use the PostgreSQL current_date function to get the current system date.

SELECT current_date;

 current_date
--------------
 2022-05-14