PostgreSQL current_date function.

Preamble

The current_date function in PostgreSQL returns the current date.

Syntax of current_date function in PostgreSQL

current_date

Parameters and function arguments

• There are no parameters or arguments for the PostgreSQL function.

The current_date function returns the current date in ‘YYYY-MM-DD’ format. Do not put brackets () after current_date function.

The current_date function can be used in future versions of PostgreSQL

Let’s look at some examples of current_date functions to see how to use the current_date function in PostgreSQL.
For example:

SELECT current_date;

--Result: 2019-04-23

SELECT current_date + 1;

--Result: 2019-04-24

Date functions in PostgreSQL , Time functions in PostgreSQL

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.