How to Get the Current Date in PostgreSQL

Problem

You’d like to get the current date in a PostgreSQL database.

Solution

We’ll use the function CURRENT_DATE to get the current date:

SELECT CURRENT_DATE;

Here’s the result of the query:

2019-10-24

Discussion

The PostgreSQL CURRENT_DATE function returns the current date (the system date on the machine running PostgreSQL) as a value in the 'YYYY-MM-DD' format. In this format, YYYY is a 4-digit year, MM is a 2-digit month, and DD is a 2-digit day. The returned value is a date data type.

As you notice, this function has no brackets. Look at the next example:

SELECT CURRENT_DATE;

Here’s the result of the query:

2019-10-24