Saturday, May 5, 2018

Using ADD_MONTHS in PLSQL Query

https://randomsrsolutions.blogspot.com/2018/05/using-addmonths-in-plsql-query.html

ADD_MONTHS(date, n): Adds n number of calendar months to date. The value of n must be an integer and can be negative.


select ADD_MONTHS('14-AUG-2008',1) AF_1_MON,
ADD_MONTHS('14-AUG-2008',6) AF_6_MONS,
ADD_MONTHS('14-AUG-2008',12) AF_1_YEAR,
ADD_MONTHS('14-AUG-2008',12*3)  AF_3_YEARS,
ADD_MONTHS('14-AUG-2008',-3)  BF_3_MONS,
ADD_MONTHS('14-AUG-2008',-12*3)  BF_3_YEARS
from Dual;

AF_1_MON   AF_6_MONS   AF_1_YEAR   AF_3_YEARS    BF_3_MONS   BF_3_YEARS
14-SEP-08       14-FEB-09        14-AUG-09        14-AUG-11        14-MAY-08       14-AUG-05

No comments:

Post a Comment

XLA to GL Link

  https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT             acr.cash_receipt_id,             acr.receipt_number,       ...