http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FDate_Timestamp_Functions%2FADD_MONTHS 2026-05-24T08:01:24Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Date_Timestamp_Functions/ADD_MONTHS&diff=3042&oldid=prev 2010-05-26T13:45:46Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Date_Timestamp_Functions/ADD_MONTHS&diff=3043&oldid=prev 2010-05-26T10:04:53Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== ADD_MONTHS(x, y) gets the result of adding y months to x.==<br /> <br /> &lt;p&gt;If y is negative, y months are subtracted from x.&lt;/p&gt;<br /> &lt;p&gt;The following example adds 13 months to January 1, 2005:&lt;/p&gt;<br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT ADD_MONTHS(&quot;01-JAN-2005&quot;, 13)<br /> 2 FROM dual;<br /> ADD_MONTH<br /> ---------<br /> 01-FEB-06<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Add Negative time==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT TO_CHAR(TO_CHAR(ADD_MONTHS(SYSDATE, -23), &quot;ddMONyyyy&quot;)) &quot;- 23 mon&quot;<br /> 2 FROM dual;<br /> - 23 mon<br /> ---------<br /> 29JUN2005<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Combine ADD_MONTHS() function with To_Date==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT ADD_MONTHS(TO_DATE(&quot;01-JAN-2005 19:15:26&quot;,<br /> 2 &quot;DD-MON-YYYY HH24:MI:SS&quot;), 2)<br /> 3 FROM dual;<br /> ADD_MONTH<br /> ---------<br /> 01-MAR-05<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Combine ADD_MONTHS() with TO_CHAR() and TO_DATE==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT TO_CHAR(ADD_MONTHS(TO_DATE(&quot;01-JAN-2005 19:15:26&quot;,<br /> 2 &quot;DD-MON-YYYY HH24:MI:SS&quot;), 2), &quot;DD-MON-YYYY HH24:MI:SS&quot;)<br /> 3 FROM dual;<br /> TO_CHAR(ADD_MONTHS(T<br /> --------------------<br /> 01-MAR-2005 19:15:26<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == SELECT ADD_MONTHS(&quot;01-JAN-2005&quot;, 3) FROM dual;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT ADD_MONTHS(&quot;01-JAN-2005&quot;, 3) FROM dual;<br /> ADD_MONTH<br /> ---------<br /> 01-APR-05<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == SELECT ADD_MONTHS(&quot;01-JAN-2005&quot;, -3) FROM dual; (2)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT ADD_MONTHS(&quot;01-JAN-2005&quot;, -3) FROM dual;<br /> ADD_MONTH<br /> ---------<br /> 01-OCT-04&lt;/source&gt;<br /> <br /> <br /> <br /> == SELECT ADD_MONTHS(&quot;28-NOV-05&quot;, 1) FROM DUAL;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> ADD_MONTH<br /> ---------<br /> 28-DEC-05&lt;/source&gt;<br /> <br /> <br /> <br /> == SELECT ADD_MONTHS(&quot;29-NOV-05&quot;, 1) FROM DUAL;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> ADD_MONTH<br /> ---------<br /> 29-DEC-05&lt;/source&gt;<br /> <br /> <br /> <br /> == SELECT ADD_MONTHS(&quot;30-NOV-05&quot;, 1) FROM DUAL;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> ADD_MONTH<br /> ---------<br /> 31-DEC-05&lt;/source&gt;<br /> <br /> <br /> <br /> == SELECT ADD_MONTHS(&quot;31-DEC-05&quot;, -1) FROM DUAL;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> ADD_MONTH<br /> ---------<br /> 30-NOV-05<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Subtract 13 months from the January 1, 2005==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT ADD_MONTHS(&quot;01-JAN-2005&quot;, -13) FROM dual;<br /> ADD_MONTH<br /> ---------<br /> 01-DEC-03<br /> SQL&gt;&lt;/source&gt;</div>

Admin