PostgreSQL CURRENT DATE Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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

 

Example : PostgreSQL CURRENT_DATE() function

SELECT current_date;

Output :

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

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