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
|
PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.
|
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.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
How to Optimize Energy and Utilities Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
- 13 August 2026
- Database Performance Management
Introduction Energy and utility companies operate highly complex digital infrastructures supporting electricity generation, transmission, distribution, water services, natural gas, renewable energy, and customer operations. Every smart meter reading, grid event, outage record, customer payment, asset maintenance activity, and energy transaction generates data that must be processed efficiently. Enteros helps energy and utility organizations optimize database … Continue reading “How to Optimize Energy and Utilities Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”
How to Optimize Real Estate Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
Introduction Real estate organizations increasingly depend on digital platforms to manage property portfolios, transactions, leasing, facilities, tenants, financial operations, and customer experiences. Every property listing, lease transaction, maintenance request, payment, tenant interaction, and financial report depends on enterprise databases. Enteros helps real estate organizations optimize database performance through Database Observability, AI-powered Analytics, SQL Performance Intelligence, … Continue reading “How to Optimize Real Estate Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”
How to Optimize Higher Education Technology with Enteros Database Software, AI-Powered Analytics, and Database Observability
- 12 August 2026
- Database Performance Management
Introduction Universities and higher education institutions increasingly depend on digital infrastructure to manage student records, admissions, learning platforms, research systems, finance, housing, libraries, and campus services. Every student registration, tuition payment, course enrollment, examination record, research transaction, and digital learning interaction depends on enterprise databases. Enteros helps higher education institutions optimize these environments through Database … Continue reading “How to Optimize Higher Education Technology with Enteros Database Software, AI-Powered Analytics, and Database Observability”
Improving Healthcare IT Performance and Cost Efficiency with AIOps and FinOps
Introduction Healthcare organizations are undergoing rapid digital transformation. Electronic health records (EHRs), telemedicine platforms, patient portals, digital diagnostics, healthcare insurance applications, medical imaging systems, pharmacy platforms, and connected medical devices increasingly depend on complex IT infrastructure. At the same time, healthcare providers must deliver reliable digital services while controlling infrastructure costs. Even a short application … Continue reading “Improving Healthcare IT Performance and Cost Efficiency with AIOps and FinOps”