📄 group__g__timestamp.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>OCILIB (C Driver for Oracle): Timestamps and intervals manipulation</title><link href="doxygen.css" rel="stylesheet" type="text/css"><link href="tabs.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.5.4 --><div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="annotated.html"><span>Data Structures</span></a></li> <li><a href="files.html"><span>Files</span></a></li> </ul></div><h1>Timestamps and intervals manipulation</h1><hr><a name="_details"></a><h2>Detailed Description</h2>OCILIB encapsulates Oracle :<p><ul><li>SQL timestamp datatype within <a class="el" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> structure</li><li>SQL interval datatype within <a class="el" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> structure</li></ul><p>Basically, the <a class="el" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> and <a class="el" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> routines are wrappers around the Oracle OCIDatetime and OCIInterval APIs<p><dl class="user" compact><dt><b>Examples</b></dt><dd><div class="fragment"><pre class="fragment"><span class="preprocessor">#include "ocilib.h"</span> <span class="preprocessor">#define SIZE_STR 260</span><span class="preprocessor"></span><span class="keywordtype">int</span> main(<span class="keywordtype">void</span>){ <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> *tm; <a class="code" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> *itv; <span class="keywordflow">if</span> (!<a class="code" href="group__g__init.html#gcdb642d75f7c8478e083634144bc813c" title="Initializes the library.">OCI_Initialize</a>(NULL, NULL, OCI_ENV_DEFAULT)) <span class="keywordflow">return</span> EXIT_FAILURE; tm = <a class="code" href="group__g__timestamp.html#g5c590ea371920703997cd7bea126ad9d" title="Create a local Timestamp instance.">OCI_TimestampCreate</a>(NULL, OCI_TIMESTAMP); itv = <a class="code" href="group__g__timestamp.html#g4748278cf01c5e927137ce3342038fd7" title="Create a local interval object.">OCI_IntervalCreate</a>(NULL, OCI_INTERVAL_DS); <a class="code" href="group__g__timestamp.html#g1ca2a6227987c26ef8f561d47ffc24fb" title="Stores the system current date and time as a timestamp value with time zone into...">OCI_TimestampSysTimeStamp</a>(tm); <a class="code" href="group__g__timestamp.html#gb737b5a0c898dde2381fd095dd4e2b65" title="Convert a timestamp value from the given timestamp handle to a string.">OCI_TimestampToText</a>(tm, <span class="stringliteral">"DD/MM/YYYY HH24:MI:SS:FF3"</span>, SIZE_STR, str, 3); printf(<span class="stringliteral">"%s\n"</span>, str); <a class="code" href="group__g__timestamp.html#g5fa498aad5bf6a1b2bd899a0f054432a" title="Set the day / time portion if the given interval handle.">OCI_IntervalSetDaySecond</a>(itv, 1,1,1,1,0); <a class="code" href="group__g__timestamp.html#g42e529414447c9e906916029cfc5895f" title="Convert an interval value from the given interval handle to a string.">OCI_IntervalToText</a>(itv, 10, 10, SIZE_STR, str); printf(<span class="stringliteral">"%s\n"</span>, str); <a class="code" href="group__g__timestamp.html#g43028a0463f25bcd9665993a244572e7" title="Add an interval value to a timestamp value of a timestamp handle.">OCI_TimestampIntervalAdd</a>(tm, itv); <a class="code" href="group__g__timestamp.html#gb737b5a0c898dde2381fd095dd4e2b65" title="Convert a timestamp value from the given timestamp handle to a string.">OCI_TimestampToText</a>(tm, <span class="stringliteral">"DD/MM/YYYY HH24:MI:SS:FF3"</span>, SIZE_STR, str, 3); printf(<span class="stringliteral">"%s\n"</span>, str); <a class="code" href="group__g__init.html#g639706aa8e9689c7ebffc018fac6d3ae" title="Clean up all resources allocated by the library.">OCI_Cleanup</a>(); <span class="keywordflow">return</span> EXIT_SUCCESS;}</pre></div> </dd></dl><p><table border="0" cellpadding="0" cellspacing="0"><tr><td></td></tr><tr><td colspan="2"><br><h2>Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT <a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g5c590ea371920703997cd7bea126ad9d">OCI_TimestampCreate</a> (<a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *con, unsigned int type)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Create a local Timestamp instance. <a href="#g5c590ea371920703997cd7bea126ad9d"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g60e9851db1175d6b650f9df00db274da">OCI_TimestampFree</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Free an <a class="el" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> handle. <a href="#g60e9851db1175d6b650f9df00db274da"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#ga6a59f18f308bd55841654bd66c6cee6">OCI_TimestampGetType</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the type of the given Timestamp object. <a href="#ga6a59f18f308bd55841654bd66c6cee6"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g6b8356c2fcaa984d2d63edd5cc7a357b">OCI_TimestampAssign</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, <a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp_src)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Assign the value of a timestamp handle to another one. <a href="#g6b8356c2fcaa984d2d63edd5cc7a357b"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#gb23aaba98e752b92725045205bd55a03">OCI_TimestampCheck</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Check if the given timestamp is valid. <a href="#gb23aaba98e752b92725045205bd55a03"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g8063cc410dc2ed2a80aa9a434e759b0b">OCI_TimestampCompare</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, <a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Compares two timestamp handles. <a href="#g8063cc410dc2ed2a80aa9a434e759b0b"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#gc159b440ab075cd969f2e6d3589a9fa4">OCI_TimestampConstruct</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, int year, int month, int day, int hour, int min, int sec, int fsec, const mtext *timezone)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set a timestamp handle value. <a href="#gc159b440ab075cd969f2e6d3589a9fa4"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g7eec8396448c7466944fd37d7386bc89">OCI_TimestampConvert</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, <a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp_src)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert one timestamp value from one type to another. <a href="#g7eec8396448c7466944fd37d7386bc89"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#gcd23e54055e335c4d04a165ab6858d92">OCI_TimestampFromText</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, const mtext *str, const mtext *fmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert a string to a timestamp and store it in the given timestamp handle. <a href="#gcd23e54055e335c4d04a165ab6858d92"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#gb737b5a0c898dde2381fd095dd4e2b65">OCI_TimestampToText</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, const mtext *fmt, int size, mtext *str, int precision)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert a timestamp value from the given timestamp handle to a string. <a href="#gb737b5a0c898dde2381fd095dd4e2b65"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#ge8b95bad27ed1bce2e9753e30d3fa26b">OCI_TimestampGetDate</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, int *year, int *month, int *day)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Extract the date part from a timestamp handle. <a href="#ge8b95bad27ed1bce2e9753e30d3fa26b"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g4c56996d6dc31b7a4373daa0018c88e1">OCI_TimestampGetTime</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, int *hour, int *min, int *sec, int *fsec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Extract the time portion from a timestamp handle. <a href="#g4c56996d6dc31b7a4373daa0018c88e1"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g364aa28b777ed77ac6c66b7dd95926e8">OCI_TimestampGetDateTime</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, int *year, int *month, int *day, int *hour, int *min, int *sec, int *fsec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Extract the date and time parts from a date handle. <a href="#g364aa28b777ed77ac6c66b7dd95926e8"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#gc118f3649052c1460ac309abd2f7e2ba">OCI_TimestampGetTimeZoneName</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, int size, mtext *str)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the time zone name of a timestamp handle. <a href="#gc118f3649052c1460ac309abd2f7e2ba"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g807ca5a3e663b234945f9a018e88badb">OCI_TimestampGetTimeZoneOffset</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, int *hour, int *min)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the time zone (hour, minute) portion of a timestamp handle. <a href="#g807ca5a3e663b234945f9a018e88badb"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g43028a0463f25bcd9665993a244572e7">OCI_TimestampIntervalAdd</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Add an interval value to a timestamp value of a timestamp handle. <a href="#g43028a0463f25bcd9665993a244572e7"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#ga3353b2e9b5ed9e7ffa2019e9232246c">OCI_TimestampIntervalSub</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Subtract an interval value from a timestamp value of a timestamp handle. <a href="#ga3353b2e9b5ed9e7ffa2019e9232246c"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#ge97028efa9db15ea51db83a8dd27de56">OCI_TimestampSubtract</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, <a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp2, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Store the difference of two timestamp handles into an interval handle. <a href="#ge97028efa9db15ea51db83a8dd27de56"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g1ca2a6227987c26ef8f561d47ffc24fb">OCI_TimestampSysTimeStamp</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Stores the system current date and time as a timestamp value with time zone into the timestamp handle. <a href="#g1ca2a6227987c26ef8f561d47ffc24fb"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g5b38e5b80794e324b17adf60dc851b03">OCI_TimestampToCTime</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, struct tm *ptm, time_t *pt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Affect an <a class="el" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> handle value to ISO C time datatypes. <a href="#g5b38e5b80794e324b17adf60dc851b03"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g69f6172371a6a70fcecb2c4e1d34a360">OCI_TimestampFromCTime</a> (<a class="el" href="struct_o_c_i___timestamp.html">OCI_Timestamp</a> *tmsp, struct tm *ptm, time_t t)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Affect ISO C time datatypes values to an <a class="el" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> handle. <a href="#g69f6172371a6a70fcecb2c4e1d34a360"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g4748278cf01c5e927137ce3342038fd7">OCI_IntervalCreate</a> (<a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *con, unsigned int type)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Create a local interval object. <a href="#g4748278cf01c5e927137ce3342038fd7"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g7623b368ab3486c15c6d671054fac3e3">OCI_IntervalFree</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Free an <a class="el" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> handle. <a href="#g7623b368ab3486c15c6d671054fac3e3"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g29704a6c17b3938c63988edc6364907e">OCI_IntervalGetType</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the type of the given Interval object. <a href="#g29704a6c17b3938c63988edc6364907e"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g479e6e2db5d78dee2b396190c577019a">OCI_IntervalAssign</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv_src)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Assign the value of a interval handle to another one. <a href="#g479e6e2db5d78dee2b396190c577019a"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g2f89edaeae7952774fff0cc0366e635f">OCI_IntervalCheck</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Check if the given interval is valid. <a href="#g2f89edaeae7952774fff0cc0366e635f"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g136738d0987078d8ef34c9cfc109e63f">OCI_IntervalCompare</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Compares two interval handles. <a href="#g136738d0987078d8ef34c9cfc109e63f"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g7f325860c2e5f311309e04556d2a4635">OCI_IntervalFromText</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, const mtext *str)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert a string to an interval and store it in the given interval handle. <a href="#g7f325860c2e5f311309e04556d2a4635"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g42e529414447c9e906916029cfc5895f">OCI_IntervalToText</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, int leading_prec, int fraction_prec, int size, mtext *str)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert an interval value from the given interval handle to a string. <a href="#g42e529414447c9e906916029cfc5895f"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g144fa5b4841b3a8ebced991c3639ba00">OCI_IntervalFromTimeZone</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, const mtext *str)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Correct an interval handle value with the given time zone. <a href="#g144fa5b4841b3a8ebced991c3639ba00"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g165e94c916375ea604737a2348c4d83b">OCI_IntervalGetDaySecond</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, int *day, int *hour, int *min, int *sec, int *fsec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the day / time portion of an interval handle. <a href="#g165e94c916375ea604737a2348c4d83b"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#gf0632925b430ad8ff145e29936b7b592">OCI_IntervalGetYearMonth</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, int *year, int *month)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the year / month portion of an interval handle. <a href="#gf0632925b430ad8ff145e29936b7b592"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g5fa498aad5bf6a1b2bd899a0f054432a">OCI_IntervalSetDaySecond</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, int day, int hour, int min, int sec, int fsec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the day / time portion if the given interval handle. <a href="#g5fa498aad5bf6a1b2bd899a0f054432a"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g05a06f783659c6652c38319688d77526">OCI_IntervalSetYearMonth</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, int year, int month)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the year / month portion if the given Interval handle. <a href="#g05a06f783659c6652c38319688d77526"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g7065230b2482155997928190cdef6ab8">OCI_IntervalAdd</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Adds an interval handle value to another. <a href="#g7065230b2482155997928190cdef6ab8"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__timestamp.html#g6e0044488c4abb1111f7c1173aed8877">OCI_IntervalSubtract</a> (<a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv, <a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> *itv2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Subtract an interval handle value from another. <a href="#g6e0044488c4abb1111f7c1173aed8877"></a><br></td></tr></table><hr><h2>Function Documentation</h2><a class="anchor" name="g7065230b2482155997928190cdef6ab8"></a><!-- doxytag: member="ocilib.h::OCI_IntervalAdd" ref="g7065230b2482155997928190cdef6ab8" args="(OCI_Interval *itv, OCI_Interval *itv2)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalAdd </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___interval.html">OCI_Interval</a> * </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> * </td> <td class="paramname"> <em>itv2</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Adds an interval handle value to another. <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> </td><td>- Interval handle from witch to add </td></tr> <tr><td valign="top"></td><td valign="top"><em>itv2</em> </td><td>- Interval handle to add</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#l00599">599</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>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -