Back to list PostgreSQL How to Get the Current Date in PostgreSQL Database: PostgreSQL Operators:CURRENT_DATE 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 Recommended courses: SQL Basics SQL Practice Set Recommended articles: 18 Useful Important SQL Functions to Learn ASAP Performing Calculations on Date- and Time-Related Values How Often Employees Are Running Late for Work: SQL Datetime and Interval SQL Arithmetic See also: How to Get the Current Date and Time with Time Zone Offset in PostgreSQL How to Get the Current Date and Time (Without Time Zone) in PostgreSQL How to Get the Current Time (Without Time Zone) in PostgreSQL How to Get the Current Date in PostgreSQL Tags: PostgreSQL Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.