PostgreSQL CURRENT_DATE Function

The PostgreSQL CURRENT_DATE function returns the current date. This function returns the current date as a 'YYYY-MM-DD' format.

CURRENT_DATE

Note: Do not put parentheses () after the CURRENT_DATE function.

Returns the current date.

The example below shows the usage of CURRENT_DATE function.

SELECT CURRENT_DATE;
Result: '2021-12-26'

SELECT CURRENT_DATE + 0;
Result: '2021-12-26'

SELECT CURRENT_DATE + 1;
Result: '2021-12-27'

Consider a database table called Employee with the following records:

EmpID	Name	City	Age	Date_of_Joining
1	John	London	25	2018-05-25
2	Marry	New York	24	2018-10-15
3	Jo	Paris	27	2019-06-09
4	Kim	Amsterdam	30	2019-09-21
5	Ramesh	New Delhi	28	2019-10-25

To insert a new record in this table, the following statement can be used.

INSERT INTO Employee 
VALUES (6, 'Suresh', 'Mumbai', 28, CURRENT_DATE);

-- see the result
SELECT * FROM Employee;

This will produce a result similar to:

EmpID	Name	City	Age	Date_of_Joining
1	John	London	25	2018-05-25
2	Marry	New York	24	2018-10-15
3	Jo	Paris	27	2019-06-09
4	Kim	Amsterdam	30	2019-09-21
5	Ramesh	New Delhi	28	2019-10-25
6	Suresh	Mumbai	28	2021-12-26