group__g__timestamp.html

oci的源码,可以在任何平台上编译,相当方便实用

</div>
</div><p>
<a class="anchor" name="g479e6e2db5d78dee2b396190c577019a"></a><!-- doxytag: member="ocilib.h::OCI_IntervalAssign" ref="g479e6e2db5d78dee2b396190c577019a" args="(OCI_Interval *itv, OCI_Interval *itv_src)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalAssign           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *&nbsp;</td>
          <td class="paramname"> <em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *&nbsp;</td>
          <td class="paramname"> <em>itv_src</em></td><td>&nbsp;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td><td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Assign the value of a interval handle to another one. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>itv</em>&nbsp;</td><td>- Destination interval handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>itv_src</em>&nbsp;</td><td>- Source interval handle</td></tr>
  </table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Definition at line <a class="el" href="interval_8c-source.html#l00203">203</a> of file <a class="el" href="interval_8c-source.html">interval.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00532">OCI_Interval::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00533">OCI_Interval::err</a>, and <a class="el" href="ocilib__types_8h-source.html#l00527">OCI_Interval::handle</a>.</p>

<p>Referenced by <a class="el" href="group__g__collection.html#g7867804d8ad361dbc6ab8728b835ef29">OCI_ElemSetInterval()</a>, and <a class="el" href="group__g__usertypes.html#g60095ee4f6bef54c80cd7147d1c2309a">OCI_ObjectSetInterval()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g2f89edaeae7952774fff0cc0366e635f"></a><!-- doxytag: member="ocilib.h::OCI_IntervalCheck" ref="g2f89edaeae7952774fff0cc0366e635f" args="(OCI_Interval *itv)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_IntervalCheck           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *&nbsp;</td>
          <td class="paramname"> <em>itv</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Check if the given interval is valid. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>itv</em>&nbsp;</td><td>- Interval handle</td></tr>
  </table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><ul>
<li>Zero if the interval value is valid</li><li>Any other value means the interval value is invalid </li></ul>
</dd></dl>

<p>Definition at line <a class="el" href="interval_8c-source.html#l00233">233</a> of file <a class="el" href="interval_8c-source.html">interval.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00532">OCI_Interval::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00533">OCI_Interval::err</a>, and <a class="el" href="ocilib__types_8h-source.html#l00527">OCI_Interval::handle</a>.</p>

</div>
</div><p>
<a class="anchor" name="g136738d0987078d8ef34c9cfc109e63f"></a><!-- doxytag: member="ocilib.h::OCI_IntervalCompare" ref="g136738d0987078d8ef34c9cfc109e63f" args="(OCI_Interval *itv, OCI_Interval *itv2)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_IntervalCompare           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *&nbsp;</td>
          <td class="paramname"> <em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *&nbsp;</td>
          <td class="paramname"> <em>itv2</em></td><td>&nbsp;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td><td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Compares two interval handles. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>itv</em>&nbsp;</td><td>- Interval1 handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>itv2</em>&nbsp;</td><td>- Interval2 handle</td></tr>
  </table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><ul>
<li>-1 if interval1 is smaller than interval2,</li><li>0 if they are equal</li><li>1 if interval1 is greater than interval2. </li></ul>
</dd></dl>

<p>Definition at line <a class="el" href="interval_8c-source.html#l00264">264</a> of file <a class="el" href="interval_8c-source.html">interval.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00532">OCI_Interval::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00533">OCI_Interval::err</a>, and <a class="el" href="ocilib__types_8h-source.html#l00527">OCI_Interval::handle</a>.</p>

</div>
</div><p>
<a class="anchor" name="g4748278cf01c5e927137ce3342038fd7"></a><!-- doxytag: member="ocilib.h::OCI_IntervalCreate" ref="g4748278cf01c5e927137ce3342038fd7" args="(OCI_Connection *con, unsigned int type)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a>* OCI_API OCI_IntervalCreate           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *&nbsp;</td>
          <td class="paramname"> <em>con</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>type</em></td><td>&nbsp;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td><td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Create a local interval object. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>con</em>&nbsp;</td><td>- Connection handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>type</em>&nbsp;</td><td>- Type of Interval</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>From version 2.5.0, parameter 'con' can be NULL in order to manipulate intervals independently from database connections<p>
Interval type can be :</dd></dl>
<ul>
<li>OCI_INTERVAL_YM : year / month interval</li><li>OCI_INTERVAL_DS : date/ time interval</li></ul>
<p>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>Return the Interval handle on success otherwise NULL on failure </dd></dl>

<p>Definition at line <a class="el" href="interval_8c-source.html#l00126">126</a> of file <a class="el" href="interval_8c-source.html">interval.c</a>.</p>

</div>
</div><p>
<a class="anchor" name="g7623b368ab3486c15c6d671054fac3e3"></a><!-- doxytag: member="ocilib.h::OCI_IntervalFree" ref="g7623b368ab3486c15c6d671054fac3e3" args="(OCI_Interval *itv)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalFree           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *&nbsp;</td>
          <td class="paramname"> <em>itv</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Free an <a class="el" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> handle. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>itv</em>&nbsp;</td><td>- Interval handle</td></tr>
  </table>
</dl>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>Only Intervals created with <a class="el" href="group__g__timestamp.html#g4748278cf01c5e927137ce3342038fd7" title="Create a local interval object.">OCI_IntervalCreate()</a> should be freed by <a class="el" href="group__g__timestamp.html#g7623b368ab3486c15c6d671054fac3e3" title="Free an OCI_Interval handle.">OCI_IntervalFree()</a></dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Definition at line <a class="el" href="interval_8c-source.html#l00153">153</a> of file <a class="el" href="interval_8c-source.html">interval.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00532">OCI_Interval::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00527">OCI_Interval::handle</a>, <a class="el" href="ocilib__types_8h-source.html#l00531">OCI_Interval::hstate</a>, and <a class="el" href="ocilib__types_8h-source.html#l00534">OCI_Interval::type</a>.</p>

<p>Referenced by <a class="el" href="group__g__collection.html#gdf1010d812aa53c3b27d991fa47b4f98">OCI_ElemFree()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g7f325860c2e5f311309e04556d2a4635"></a><!-- doxytag: member="ocilib.h::OCI_IntervalFromText" ref="g7f325860c2e5f311309e04556d2a4635" args="(OCI_Interval *itv, const mtext *str)" -->
<div class="memitem">