Preamble
The Oracle/PLSQL ADD_MONTHS function returns a date plus n months.
Oracle/PLSQL syntax of ADD_MONTHS function
ADD_MONTHS( date1_id, n_id )
Parameters and function arguments
- date1_id – start date.
- n_id – number of months that will be added to date1.
Function ADD_MONTHS returns date.
The ADD_MONTHS function can be used in the following Oracle/PLSQL versions
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
Let’s consider some examples of the ADD_MONTHS function and learn how to use ADD_MONTHS function in Oracle.
SELECT ADD_MONTHS('01-AUG-14', 3) FROM DUAL;
--Result: 01.11.2014
SELECT ADD_MONTHS('01-AUG-14', -3) FROM DUAL;
--Result: 01.05.2014
SELECT ADD_MONTHS('21-AUG-14', -3) FROM DUAL;
--Result: 21.05.2014
SELECT ADD_MONTHS('31-January-14', 1) FROM DUAL;
--Result: 28.02.2014
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
Reducing Cloud Infrastructure Waste in BFSI with AIOps, FinOps, and Database Analytics
- 25 August 2026
- Database Performance Management
Introduction Banking, Financial Services, and Insurance (BFSI) organizations are rapidly adopting cloud infrastructure to support digital banking, payments, lending, insurance, fraud detection, financial analytics, and customer-facing applications. Cloud technology provides the scalability and flexibility needed to deliver always-on financial services, but it also creates a growing challenge: how can BFSI organizations control infrastructure waste without … Continue reading “Reducing Cloud Infrastructure Waste in BFSI with AIOps, FinOps, and Database Analytics”
How AI-Driven FinOps and AIOps Improve Performance Across Banking Cloud Environments
Introduction The banking industry is rapidly transitioning from traditional infrastructure models toward cloud-native, hybrid, and multi-cloud environments. Digital banking applications, payment platforms, lending systems, customer portals, fraud detection platforms, and financial analytics increasingly depend on cloud infrastructure to deliver scalable and reliable services. This transformation provides banks with greater flexibility, but it also introduces a … Continue reading “How AI-Driven FinOps and AIOps Improve Performance Across Banking Cloud Environments”
How to Optimize Telecom Database Infrastructure with Enteros Database Software, AIOps, and Cloud FinOps
Introduction Telecommunications companies operate some of the most complex technology environments in the world. Subscriber management, billing, charging, network inventory, service provisioning, CRM, usage analytics, 5G, IoT, edge computing, and digital customer platforms all generate massive database workloads. As telecom operators expand 5G, cloud-native architectures, edge computing, and AI, the amount and complexity of data … Continue reading “How to Optimize Telecom Database Infrastructure with Enteros Database Software, AIOps, and Cloud FinOps”
Building Resilient BFSI Applications with Predictive AIOps and FinOps Intelligence
- 23 August 2026
- Database Performance Management
Introduction The Banking, Financial Services, and Insurance (BFSI) industry is undergoing a rapid digital transformation. Mobile banking, digital payments, online lending, insurance platforms, wealth management applications, and real-time financial services now depend on highly available and scalable IT infrastructure. Customers expect BFSI applications to be fast, secure, and available around the clock. Even a short … Continue reading “Building Resilient BFSI Applications with Predictive AIOps and FinOps Intelligence”