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
Subscribe to:
Post Comments (Atom)
XLA to GL Link
https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT acr.cash_receipt_id, acr.receipt_number, ...
-
https://plsqlquery.blogspot.com/2018/05/using-outer-joins-in-plsql-query.html We use Outer Join when mismatched Values to be displayed ...
-
https://plsqlquery.blogspot.com/2018/05/using-trim-in-plsql-query.html The Oracle/PLSQL TRIM function removes all specified characters eit...
-
https://randomsrsolutions.blogspot.com/2018/05/using-trunc-function-with-numbers-in.html The TRUNC function Truncates the Column, Expressi...
No comments:
Post a Comment