http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FDate_Timestamp_Functions%2FNUMTODSINTERVAL 2026-05-24T01:31:00Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Date_Timestamp_Functions/NUMTODSINTERVAL&diff=3012&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/NUMTODSINTERVAL&diff=3013&oldid=prev 2010-05-26T10:04:50Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== NUMTODSINTERVAL()==<br /> <br /> &lt;p&gt;NUMTODSINTERVAL(x, interval_unit) converts the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit.&lt;/p&gt;<br /> &lt;p&gt;You may set interval_unit to DAY , HOUR , MINUTE , or SECOND.&lt;/p&gt;<br /> 13. 13. NUMTODSINTERVAL<br /> 13. 13. 1. <br /> NUMTODSINTERVAL()<br /> 13. 13. 2. <br /> &lt;A href=&quot;/Tutorial/Oracle/0260__Date-Timestamp-Functions/NUMTODSINTERVAL15DAY.htm&quot;&gt;NUMTODSINTERVAL(1.5, &quot;DAY&quot;)&lt;/a&gt;<br /> 13. 13. 3. <br /> &lt;A href=&quot;/Tutorial/Oracle/0260__Date-Timestamp-Functions/NUMTODSINTERVAL325HOUR.htm&quot;&gt;NUMTODSINTERVAL(3.25, &quot;HOUR&quot;)&lt;/a&gt;<br /> 13. 13. 4. <br /> &lt;A href=&quot;/Tutorial/Oracle/0260__Date-Timestamp-Functions/NUMTODSINTERVAL5MINUTE.htm&quot;&gt;NUMTODSINTERVAL(5, &quot;MINUTE&quot;)&lt;/a&gt;<br /> 13. 13. 5. <br /> &lt;A href=&quot;/Tutorial/Oracle/0260__Date-Timestamp-Functions/NUMTODSINTERVAL10123456789SECOND.htm&quot;&gt;NUMTODSINTERVAL(10.123456789, &quot;SECOND&quot;)&lt;/a&gt;<br /> <br /> == NUMTODSINTERVAL(10.123456789, &quot;SECOND&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT<br /> 2 NUMTODSINTERVAL(10.123456789, &quot;SECOND&quot;)<br /> 3 FROM dual;<br /> NUMTODSINTERVAL(10.123456789,&quot;SECOND&quot;)<br /> ---------------------------------------------------------------------------<br /> +000000000 00:00:10.123456789<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == NUMTODSINTERVAL(1.5, &quot;DAY&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT<br /> 2 NUMTODSINTERVAL(1.5, &quot;DAY&quot;)<br /> 3 FROM dual;<br /> NUMTODSINTERVAL(1.5,&quot;DAY&quot;)<br /> ---------------------------------------------------------------------------<br /> +000000001 12:00:00.000000000<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == NUMTODSINTERVAL(3.25, &quot;HOUR&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT<br /> 2 NUMTODSINTERVAL(3.25, &quot;HOUR&quot;)<br /> 3 FROM dual;<br /> NUMTODSINTERVAL(3.25,&quot;HOUR&quot;)<br /> ---------------------------------------------------------------------------<br /> +000000000 03:15:00.000000000<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == NUMTODSINTERVAL(5, &quot;MINUTE&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; SELECT<br /> 2 NUMTODSINTERVAL(5, &quot;MINUTE&quot;)<br /> 3 FROM dual;<br /> NUMTODSINTERVAL(5,&quot;MINUTE&quot;)<br /> ---------------------------------------------------------------------------<br /> +000000000 00:05:00.000000000<br /> SQL&gt;&lt;/source&gt;</div>

Admin