📄 group__g__date.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): Date/time 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>Date/time manipulation</h1><hr><a name="_details"></a><h2>Detailed Description</h2>OCILIB encapsulates Oracle SQL Date datatype within <a class="el" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> structure<p>Basically, the <a class="el" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> routines are wrappers around the Oracle OCIDate APIs<p><dl class="user" compact><dt><b>Example</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___date.html" title="Oracle internal date representation.">OCI_Date</a> *d1, *d2; <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; d1 = <a class="code" href="group__g__date.html#ge80eacef54641a68c3b82be85f4a5042" title="Create a local date object.">OCI_DateCreate</a>(NULL); d2 = <a class="code" href="group__g__date.html#ge80eacef54641a68c3b82be85f4a5042" title="Create a local date object.">OCI_DateCreate</a>(NULL); strcpy(str, <span class="stringliteral">"13041978 20:20:12"</span>); <a class="code" href="group__g__date.html#ge0a2778f7c5646df7ea8748d7683b76b" title="Convert a string to a date and store it in the given date handle.">OCI_DateFromText</a>(d1, str, <span class="stringliteral">"DDMMYYYY HH24:MI:SS"</span>); <a class="code" href="group__g__date.html#g48334e86fc54a800a44f2c8e6759adfd" title="Convert a Date value from the given date handle to a string.">OCI_DateToText</a>(d1, <span class="stringliteral">"DD/MM/YYYY HH24:MI:SS"</span>, SIZE_STR, str); printf(<span class="stringliteral">"\nDate is %s\n"</span>, str); <a class="code" href="group__g__date.html#gd7c5c65d88b52e6ecb46b3e9ba8843dc" title="Return the current system date/time into the date handle.">OCI_DateSysDate</a>(d1); <a class="code" href="group__g__date.html#g48334e86fc54a800a44f2c8e6759adfd" title="Convert a Date value from the given date handle to a string.">OCI_DateToText</a>(d1, <span class="stringliteral">"DD/MM/YYYY HH24:MI:SS"</span>, SIZE_STR, str); printf(<span class="stringliteral">"\nSysdate is %s\n"</span>, str); <a class="code" href="group__g__date.html#g7f446c4dc922920c36601770e3d9d7d1" title="Add or subtract days to a date handle.">OCI_DateAddDays</a>(d1, 5); <a class="code" href="group__g__date.html#ga405c4bb8c705ce2dd03b51bba1ef303" title="Add or subtract months to a date handle.">OCI_DateAddMonths</a>(d1, 2); <a class="code" href="group__g__date.html#g48334e86fc54a800a44f2c8e6759adfd" title="Convert a Date value from the given date handle to a string.">OCI_DateToText</a>(d1, <span class="stringliteral">"DD/MM/YYYY HH24:MI:SS"</span>, SIZE_STR, str); printf(<span class="stringliteral">"\nDate + 5 days and 2 months is %s\n"</span>, str); <a class="code" href="group__g__date.html#gd66b48f587f3bc30b1db8cd4cb892847" title="Assign the value of a date handle to another one.">OCI_DateAssign</a>(d2, d1); <a class="code" href="group__g__date.html#g0d174f4b5db6961053807efe1698ea81" title="Place the last day of month (from the given date) into the given date.">OCI_DateLastDay</a>(d1); <a class="code" href="group__g__date.html#g48334e86fc54a800a44f2c8e6759adfd" title="Convert a Date value from the given date handle to a string.">OCI_DateToText</a>(d1, <span class="stringliteral">"DD/MM/YYYY HH24:MI:SS"</span>, SIZE_STR, str); printf(<span class="stringliteral">"\nLast day of the month : %s\n"</span>, str); printf(<span class="stringliteral">"\nNumber of days until the end of the months : %i\n"</span>, <a class="code" href="group__g__date.html#gfa9f51e0977278bc43dafdef13d7fb5e" title="Return the number of days betWeen two dates.">OCI_DateDaysBetween</a>(d1, d2)); <a class="code" href="group__g__date.html#gedf77cfe4bd5dab7909e4c2fb5173b48" title="Free an OCI_Date handle.">OCI_DateFree</a>(d1); <a class="code" href="group__g__date.html#gedf77cfe4bd5dab7909e4c2fb5173b48" title="Free an OCI_Date handle.">OCI_DateFree</a>(d2); <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___date.html">OCI_Date</a> *OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__date.html#ge80eacef54641a68c3b82be85f4a5042">OCI_DateCreate</a> (<a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *con)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Create a local date object. <a href="#ge80eacef54641a68c3b82be85f4a5042"></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__date.html#gedf77cfe4bd5dab7909e4c2fb5173b48">OCI_DateFree</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Free an <a class="el" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> handle. <a href="#gedf77cfe4bd5dab7909e4c2fb5173b48"></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__date.html#g7f446c4dc922920c36601770e3d9d7d1">OCI_DateAddDays</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int nb)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Add or subtract days to a date handle. <a href="#g7f446c4dc922920c36601770e3d9d7d1"></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__date.html#ga405c4bb8c705ce2dd03b51bba1ef303">OCI_DateAddMonths</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int nb)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Add or subtract months to a date handle. <a href="#ga405c4bb8c705ce2dd03b51bba1ef303"></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__date.html#gd66b48f587f3bc30b1db8cd4cb892847">OCI_DateAssign</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, <a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date_src)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Assign the value of a date handle to another one. <a href="#gd66b48f587f3bc30b1db8cd4cb892847"></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__date.html#gec864d9e80d658f402e8f08c829feead">OCI_DateCheck</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Check if the given date is valid. <a href="#gec864d9e80d658f402e8f08c829feead"></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__date.html#g5c85213e0dc63565c0e5d8151a480010">OCI_DateCompare</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, <a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Compares two date handles. <a href="#g5c85213e0dc63565c0e5d8151a480010"></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__date.html#gfa9f51e0977278bc43dafdef13d7fb5e">OCI_DateDaysBetween</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, <a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the number of days betWeen two dates. <a href="#gfa9f51e0977278bc43dafdef13d7fb5e"></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__date.html#ge0a2778f7c5646df7ea8748d7683b76b">OCI_DateFromText</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, const mtext *str, const mtext *fmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert a string to a date and store it in the given date handle. <a href="#ge0a2778f7c5646df7ea8748d7683b76b"></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__date.html#g48334e86fc54a800a44f2c8e6759adfd">OCI_DateToText</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, const mtext *fmt, int size, mtext *str)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert a Date value from the given date handle to a string. <a href="#g48334e86fc54a800a44f2c8e6759adfd"></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__date.html#gdc1fad15bca1a1780d22148a104bcdbd">OCI_DateGetDate</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int *year, int *month, int *day)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Extract the date part from a date handle. <a href="#gdc1fad15bca1a1780d22148a104bcdbd"></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__date.html#ga20b12b698b3c244f7482aa0ed348be5">OCI_DateGetTime</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int *hour, int *min, int *sec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Extract the time part from a date handle. <a href="#ga20b12b698b3c244f7482aa0ed348be5"></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__date.html#g0c33ca23c117aab2c8197ae7fdb657c8">OCI_DateGetDateTime</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int *year, int *month, int *day, int *hour, int *min, int *sec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Extract the date and time parts from a date handle. <a href="#g0c33ca23c117aab2c8197ae7fdb657c8"></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__date.html#g502be0f2067e0533ea383abe5a148ee9">OCI_DateSetDate</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int year, int month, int day)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the date portion if the given date handle. <a href="#g502be0f2067e0533ea383abe5a148ee9"></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__date.html#g260dfef0c32dcef83baddc636495d3ba">OCI_DateSetTime</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int hour, int min, int sec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the time portion if the given date handle. <a href="#g260dfef0c32dcef83baddc636495d3ba"></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__date.html#gb5e4890df370609f9a8267125c52123e">OCI_DateSetDateTime</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, int year, int month, int day, int hour, int min, int sec)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the date and time portions if the given date handle. <a href="#gb5e4890df370609f9a8267125c52123e"></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__date.html#g0d174f4b5db6961053807efe1698ea81">OCI_DateLastDay</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Place the last day of month (from the given date) into the given date. <a href="#g0d174f4b5db6961053807efe1698ea81"></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__date.html#g4993249f62f20d07d22eff5f52c3ce1e">OCI_DateNextDay</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, const mtext *day)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Gets the date of next day of the week, after a given date. <a href="#g4993249f62f20d07d22eff5f52c3ce1e"></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__date.html#gd7c5c65d88b52e6ecb46b3e9ba8843dc">OCI_DateSysDate</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the current system date/time into the date handle. <a href="#gd7c5c65d88b52e6ecb46b3e9ba8843dc"></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__date.html#g70185e0f00edcc02cc29a4ac9d1ab486">OCI_DateZoneToZone</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, const mtext *zone1, const mtext *zone2)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Convert a date from one zone to another zone. <a href="#g70185e0f00edcc02cc29a4ac9d1ab486"></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__date.html#g52fb4405771971a2603e3eb871b3256e">OCI_DateToCTime</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, 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___date.html" title="Oracle internal date representation.">OCI_Date</a> handle value to ISO C time datatypes. <a href="#g52fb4405771971a2603e3eb871b3256e"></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__date.html#g5022740b8e062a289d7d06a2f5bd40ca">OCI_DateFromCTime</a> (<a class="el" href="struct_o_c_i___date.html">OCI_Date</a> *date, 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___date.html" title="Oracle internal date representation.">OCI_Date</a> handle. <a href="#g5022740b8e062a289d7d06a2f5bd40ca"></a><br></td></tr></table><hr><h2>Function Documentation</h2><a class="anchor" name="g7f446c4dc922920c36601770e3d9d7d1"></a><!-- doxytag: member="ocilib.h::OCI_DateAddDays" ref="g7f446c4dc922920c36601770e3d9d7d1" args="(OCI_Date *date, int nb)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT boolean OCI_API OCI_DateAddDays </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___date.html">OCI_Date</a> * </td> <td class="paramname"> <em>date</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>nb</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>Add or subtract days to a date 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>date</em> </td><td>- Date handle </td></tr> <tr><td valign="top"></td><td valign="top"><em>nb</em> </td><td>- Number of days to add/remove</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="date_8c-source.html#l00164">164</a> of file <a class="el" href="date_8c-source.html">date.c</a>.</p><p>References <a class="el" href="ocilib__types_8h-source.html#l00496">OCI_Date::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00497">OCI_Date::err</a>, and <a class="el" href="ocilib__types_8h-source.html#l00494">OCI_Date::handle</a>.</p></div></div><p><a class="anchor" name="ga405c4bb8c705ce2dd03b51bba1ef303"></a><!-- doxytag: member="ocilib.h::OCI_DateAddMonths" ref="ga405c4bb8c705ce2dd03b51bba1ef303" args="(OCI_Date *date, int nb)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT boolean OCI_API OCI_DateAddMonths </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___date.html">OCI_Date</a> * </td> <td class="paramname"> <em>date</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>nb</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>Add or subtract months to a date 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>date</em> </td><td>- Date handle </td></tr> <tr><td valign="top"></td><td valign="top"><em>nb</em> </td><td>- Number of months to add/remove</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="date_8c-source.html#l00186">186</a> of file <a class="el" href="date_8c-source.html">date.c</a>.</p><p>References <a class="el" href="ocilib__types_8h-source.html#l00496">OCI_Date::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00497">OCI_Date::err</a>, and <a class="el" href="ocilib__types_8h-source.html#l00494">OCI_Date::handle</a>.</p></div></div><p><a class="anchor" name="gd66b48f587f3bc30b1db8cd4cb892847"></a><!-- doxytag: member="ocilib.h::OCI_DateAssign" ref="gd66b48f587f3bc30b1db8cd4cb892847" args="(OCI_Date *date, OCI_Date *date_src)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT int OCI_API OCI_DateAssign </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___date.html">OCI_Date</a> * </td> <td class="paramname"> <em>date</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="struct_o_c_i___date.html">OCI_Date</a> * </td> <td class="paramname"> <em>date_src</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td width="100%"></td> </tr>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -