Example 1
SELECT ADD_MONTHS(TO_DATE('2021-08-01-00.00.00', 'YYYY-MM-DD-HH24.MI.SS', 'NLS_CALENDAR=GREGORIAN'), 3)
FROM DUAL;Example 2
SELECT ADD_MONTHS(DATE '2016-02-29', 1)
FROM DUAL;Useful Links:
> PLSQL | ADD_MONTHS Function
Subscribe to:
Post Comments (Atom)
Popular Posts
-
To export the created File Type and File Template fully there is an existing File Template named ExtFileInsCreate (NOTE: This uses the proc... -
DECLARE t1 timestamp; t2 timestamp; BEGIN t1 := systimestamp; FOR i IN 1..1000 LOOP Dbms_Output.Put_Line(TO_CHAR(i)...
-
To demonstrate the functions, opening quick report window is used. WAY 1 - Using iURL private void menuFrmMethods_menuTest_Execute(objec...
No comments:
Post a Comment