date_8c-source.html

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

<a name="l00397"></a>00397 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00398"></a>00398 
<a name="l00399"></a><a class="code" href="group__g__date.html#g0c33ca23c117aab2c8197ae7fdb657c8">00399</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g0c33ca23c117aab2c8197ae7fdb657c8" title="Extract the date and time parts from a date handle.">OCI_DateGetDateTime</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keywordtype">int</span> *year, <span class="keywordtype">int</span> *month, 
<a name="l00400"></a>00400                                     <span class="keywordtype">int</span> *day, <span class="keywordtype">int</span> *hour, <span class="keywordtype">int</span> *min, <span class="keywordtype">int</span> *sec)
<a name="l00401"></a>00401 {
<a name="l00402"></a>00402     <span class="keywordflow">return</span> (<a class="code" href="group__g__date.html#gdc1fad15bca1a1780d22148a104bcdbd" title="Extract the date part from a date handle.">OCI_DateGetDate</a>(date, year, month, day) &amp;&amp;
<a name="l00403"></a>00403             <a class="code" href="group__g__date.html#ga20b12b698b3c244f7482aa0ed348be5" title="Extract the time part from a date handle.">OCI_DateGetTime</a>(date, hour, min, sec));
<a name="l00404"></a>00404 }
<a name="l00405"></a>00405 
<a name="l00406"></a>00406 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00407"></a>00407 <span class="comment"> * OCI_DateLastDay</span>
<a name="l00408"></a>00408 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00409"></a>00409 
<a name="l00410"></a><a class="code" href="group__g__date.html#g0d174f4b5db6961053807efe1698ea81">00410</a> <span class="keywordtype">boolean</span> OCI_API <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>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date)
<a name="l00411"></a>00411 {
<a name="l00412"></a>00412     <span class="keywordtype">boolean</span> res = TRUE;
<a name="l00413"></a>00413 
<a name="l00414"></a>00414     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);
<a name="l00415"></a>00415 
<a name="l00416"></a>00416     OCI_CALL4
<a name="l00417"></a>00417     (
<a name="l00418"></a>00418         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, 
<a name="l00419"></a>00419         
<a name="l00420"></a>00420         OCIDateLastDay(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)
<a name="l00421"></a>00421     )
<a name="l00422"></a>00422 
<a name="l00423"></a>00423     OCI_RESULT(res);
<a name="l00424"></a>00424 
<a name="l00425"></a>00425     <span class="keywordflow">return</span> res;
<a name="l00426"></a>00426 }
<a name="l00427"></a>00427 
<a name="l00428"></a>00428 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00429"></a>00429 <span class="comment"> * OCI_DateNextDay</span>
<a name="l00430"></a>00430 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00431"></a>00431 
<a name="l00432"></a><a class="code" href="group__g__date.html#g4993249f62f20d07d22eff5f52c3ce1e">00432</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g4993249f62f20d07d22eff5f52c3ce1e" title="Gets the date of next day of the week, after a given date.">OCI_DateNextDay</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keyword">const</span> mtext *day)
<a name="l00433"></a>00433 {
<a name="l00434"></a>00434     <span class="keywordtype">boolean</span> res = TRUE;
<a name="l00435"></a>00435 
<a name="l00436"></a>00436     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);
<a name="l00437"></a>00437     OCI_CHECK_PTR(OCI_IPC_STRING, day,  FALSE);
<a name="l00438"></a>00438 
<a name="l00439"></a>00439     OCI_CALL4
<a name="l00440"></a>00440     (
<a name="l00441"></a>00441         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, 
<a name="l00442"></a>00442         
<a name="l00443"></a>00443         OCIDateNextDay(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, (oratext *) day,
<a name="l00444"></a>00444                        (ub4) mtextsize(day), date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)
<a name="l00445"></a>00445     )
<a name="l00446"></a>00446 
<a name="l00447"></a>00447     OCI_RESULT(res);
<a name="l00448"></a>00448 
<a name="l00449"></a>00449     <span class="keywordflow">return</span> res;
<a name="l00450"></a>00450 }
<a name="l00451"></a>00451 
<a name="l00452"></a>00452 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00453"></a>00453 <span class="comment"> * OCI_DateSetDate</span>
<a name="l00454"></a>00454 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00455"></a>00455 
<a name="l00456"></a><a class="code" href="group__g__date.html#g502be0f2067e0533ea383abe5a148ee9">00456</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g502be0f2067e0533ea383abe5a148ee9" title="Set the date portion if the given date handle.">OCI_DateSetDate</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keywordtype">int</span> year, <span class="keywordtype">int</span> month, <span class="keywordtype">int</span> day)
<a name="l00457"></a>00457 {
<a name="l00458"></a>00458     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);
<a name="l00459"></a>00459 
<a name="l00460"></a>00460     OCIDateSetDate(date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, (sb2) year, (ub1) month, (ub1) day);
<a name="l00461"></a>00461 
<a name="l00462"></a>00462     OCI_RESULT(TRUE);
<a name="l00463"></a>00463 
<a name="l00464"></a>00464     <span class="keywordflow">return</span> TRUE;
<a name="l00465"></a>00465 }
<a name="l00466"></a>00466 
<a name="l00467"></a>00467 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00468"></a>00468 <span class="comment"> * OCI_DateSetTime</span>
<a name="l00469"></a>00469 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00470"></a>00470 
<a name="l00471"></a><a class="code" href="group__g__date.html#g260dfef0c32dcef83baddc636495d3ba">00471</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g260dfef0c32dcef83baddc636495d3ba" title="Set the time portion if the given date handle.">OCI_DateSetTime</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keywordtype">int</span> hour, <span class="keywordtype">int</span> min, <span class="keywordtype">int</span> sec)
<a name="l00472"></a>00472 {
<a name="l00473"></a>00473     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);
<a name="l00474"></a>00474 
<a name="l00475"></a>00475     OCIDateSetTime(date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, (ub1) hour, (ub1) min, (ub1) sec);
<a name="l00476"></a>00476 
<a name="l00477"></a>00477     OCI_RESULT(TRUE);
<a name="l00478"></a>00478 
<a name="l00479"></a>00479     <span class="keywordflow">return</span> TRUE;
<a name="l00480"></a>00480 }
<a name="l00481"></a>00481 
<a name="l00482"></a>00482 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00483"></a>00483 <span class="comment"> * OCI_DateSetDateTime</span>
<a name="l00484"></a>00484 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00485"></a>00485 
<a name="l00486"></a><a class="code" href="group__g__date.html#gb5e4890df370609f9a8267125c52123e">00486</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#gb5e4890df370609f9a8267125c52123e" title="Set the date and time portions if the given date handle.">OCI_DateSetDateTime</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keywordtype">int</span> year, <span class="keywordtype">int</span> month, 
<a name="l00487"></a>00487                                     <span class="keywordtype">int</span> day, <span class="keywordtype">int</span> hour, <span class="keywordtype">int</span> min, <span class="keywordtype">int</span> sec)
<a name="l00488"></a>00488 {
<a name="l00489"></a>00489     <span class="keywordflow">return</span> (<a class="code" href="group__g__date.html#g502be0f2067e0533ea383abe5a148ee9" title="Set the date portion if the given date handle.">OCI_DateSetDate</a>(date, year, month, day) &amp;&amp;
<a name="l00490"></a>00490             <a class="code" href="group__g__date.html#g260dfef0c32dcef83baddc636495d3ba" title="Set the time portion if the given date handle.">OCI_DateSetTime</a>(date, hour, min, sec));
<a name="l00491"></a>00491 }
<a name="l00492"></a>00492 
<a name="l00493"></a>00493 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00494"></a>00494 <span class="comment"> * OCI_DateSysDate</span>
<a name="l00495"></a>00495 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00496"></a>00496 
<a name="l00497"></a><a class="code" href="group__g__date.html#gd7c5c65d88b52e6ecb46b3e9ba8843dc">00497</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#gd7c5c65d88b52e6ecb46b3e9ba8843dc" title="Return the current system date/time into the date handle.">OCI_DateSysDate</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date)
<a name="l00498"></a>00498 {
<a name="l00499"></a>00499     <span class="keywordtype">boolean</span> res = TRUE;
<a name="l00500"></a>00500 
<a name="l00501"></a>00501     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);
<a name="l00502"></a>00502 
<a name="l00503"></a>00503     OCI_CALL4
<a name="l00504"></a>00504     (
<a name="l00505"></a>00505         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, 
<a name="l00506"></a>00506         
<a name="l00507"></a>00507         OCIDateSysDate(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)
<a name="l00508"></a>00508     )
<a name="l00509"></a>00509 
<a name="l00510"></a>00510     OCI_RESULT(res);
<a name="l00511"></a>00511 
<a name="l00512"></a>00512     <span class="keywordflow">return</span> res;
<a name="l00513"></a>00513 }
<a name="l00514"></a>00514 
<a name="l00515"></a>00515 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00516"></a>00516 <span class="comment"> * OCI_DateToText</span>
<a name="l00517"></a>00517 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00518"></a>00518 
<a name="l00519"></a><a class="code" href="group__g__date.html#g48334e86fc54a800a44f2c8e6759adfd">00519</a> <span class="keywordtype">boolean</span> OCI_API <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>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keyword">const</span> mtext *fmt, <span class="keywordtype">int</span> size, 
<a name="l00520"></a>00520                                mtext *str)
<a name="l00521"></a>00521 {
<a name="l00522"></a>00522     <span class="keywordtype">void</span> *ostr1 = NULL;
<a name="l00523"></a>00523     <span class="keywordtype">void</span> *ostr2 = NULL;
<a name="l00524"></a>00524     <span class="keywordtype">int</span>  osize1 = size*<span class="keyword">sizeof</span>(mtext);
<a name="l00525"></a>00525     <span class="keywordtype">int</span>  osize2 = -1;
<a name="l00526"></a>00526     <span class="keywordtype">boolean</span> res = TRUE;
<a name="l00527"></a>00527 
<a name="l00528"></a>00528     OCI_CHECK_PTR(OCI_IPC_DATE, date,  FALSE);
<a name="l00529"></a>00529     OCI_CHECK_PTR(OCI_IPC_STRING, str, FALSE);
<a name="l00530"></a>00530     OCI_CHECK_PTR(OCI_IPC_STRING, fmt, FALSE);
<a name="l00531"></a>00531 
<a name="l00532"></a>00532     <span class="comment">/* init output buffer in case of OCI failure */</span>
<a name="l00533"></a>00533