📄 date_8c-source.html
字号:
<a name="l00487"></a>00487 OCI_CALL4<a name="l00488"></a>00488 (<a name="l00489"></a>00489 res, date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-><a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, <a name="l00490"></a>00490 <a name="l00491"></a>00491 OCIDateSysDate(date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)<a name="l00492"></a>00492 )<a name="l00493"></a>00493 <a name="l00494"></a>00494 OCI_RESULT(res);<a name="l00495"></a>00495 <a name="l00496"></a>00496 <span class="keywordflow">return</span> res;<a name="l00497"></a>00497 }<a name="l00498"></a>00498 <a name="l00499"></a>00499 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00500"></a>00500 <span class="comment"> * OCI_DateToText</span><a name="l00501"></a>00501 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00502"></a>00502 <a name="l00503"></a><a class="code" href="group__g__date.html#g48334e86fc54a800a44f2c8e6759adfd">00503</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="l00504"></a>00504 mtext *str)<a name="l00505"></a>00505 {<a name="l00506"></a>00506 <span class="keywordtype">void</span> *ostr1 = NULL;<a name="l00507"></a>00507 <span class="keywordtype">void</span> *ostr2 = NULL;<a name="l00508"></a>00508 <span class="keywordtype">int</span> osize1 = size*<span class="keyword">sizeof</span>(mtext);<a name="l00509"></a>00509 <span class="keywordtype">int</span> osize2 = -1;<a name="l00510"></a>00510 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00511"></a>00511 <a name="l00512"></a>00512 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00513"></a>00513 OCI_CHECK_PTR(OCI_IPC_STRING, str, FALSE);<a name="l00514"></a>00514 OCI_CHECK_PTR(OCI_IPC_STRING, fmt, FALSE);<a name="l00515"></a>00515 <a name="l00516"></a>00516 <span class="comment">/* init output buffer in case of OCI failure */</span><a name="l00517"></a>00517 <a name="l00518"></a>00518 str[0] = 0;<a name="l00519"></a>00519 <a name="l00520"></a>00520 ostr1 = OCI_GetInputMetaString(str, &osize1);<a name="l00521"></a>00521 ostr2 = OCI_GetInputMetaString(fmt, &osize2);<a name="l00522"></a>00522 <a name="l00523"></a>00523 OCI_CALL4<a name="l00524"></a>00524 (<a name="l00525"></a>00525 res, date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-><a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, <a name="l00526"></a>00526 <a name="l00527"></a>00527 OCIDateToText(date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, (oratext *) ostr2, <a name="l00528"></a>00528 (ub1) osize2, (oratext *) NULL, (ub4) 0,<a name="l00529"></a>00529 (ub4*) &osize1, (oratext *) ostr1)<a name="l00530"></a>00530 )<a name="l00531"></a>00531 <a name="l00532"></a>00532 OCI_GetOutputMetaString(ostr1, str, &osize1);<a name="l00533"></a>00533 <a name="l00534"></a>00534 OCI_ReleaseMetaString(ostr1);<a name="l00535"></a>00535 OCI_ReleaseMetaString(ostr2);<a name="l00536"></a>00536 <a name="l00537"></a>00537 <span class="comment">/* set null string terminator*/</span><a name="l00538"></a>00538 <a name="l00539"></a>00539 str[osize1/<span class="keyword">sizeof</span>(mtext)] = 0;<a name="l00540"></a>00540 <a name="l00541"></a>00541 OCI_RESULT(res);<a name="l00542"></a>00542 <a name="l00543"></a>00543 <span class="keywordflow">return</span> res;<a name="l00544"></a>00544 }<a name="l00545"></a>00545 <a name="l00546"></a>00546 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00547"></a>00547 <span class="comment"> * OCI_DateZoneToZone</span><a name="l00548"></a>00548 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00549"></a>00549 <a name="l00550"></a><a class="code" href="group__g__date.html#g70185e0f00edcc02cc29a4ac9d1ab486">00550</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g70185e0f00edcc02cc29a4ac9d1ab486" title="Convert a date from one zone to another zone.">OCI_DateZoneToZone</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 *zone1, <a name="l00551"></a>00551 <span class="keyword">const</span> mtext *zone2)<a name="l00552"></a>00552 {<a name="l00553"></a>00553 <span class="keywordtype">void</span> *ostr1 = NULL;<a name="l00554"></a>00554 <span class="keywordtype">void</span> *ostr2 = NULL;<a name="l00555"></a>00555 <span class="keywordtype">int</span> osize1 = -1;<a name="l00556"></a>00556 <span class="keywordtype">int</span> osize2 = -1;<a name="l00557"></a>00557 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00558"></a>00558 <a name="l00559"></a>00559 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00560"></a>00560 OCI_CHECK_PTR(OCI_IPC_STRING, zone1, FALSE);<a name="l00561"></a>00561 OCI_CHECK_PTR(OCI_IPC_STRING, zone2, FALSE);<a name="l00562"></a>00562 <a name="l00563"></a>00563 ostr1 = OCI_GetInputMetaString(zone1, &osize1);<a name="l00564"></a>00564 ostr2 = OCI_GetInputMetaString(zone2, &osize2);<a name="l00565"></a>00565 <a name="l00566"></a>00566 OCI_CALL4<a name="l00567"></a>00567 (<a name="l00568"></a>00568 res, date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-><a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, <a name="l00569"></a>00569 <a name="l00570"></a>00570 OCIDateZoneToZone(date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>,<a name="l00571"></a>00571 (oratext *) ostr1, (ub4) osize1,<a name="l00572"></a>00572 (oratext *) ostr2, (ub4) osize2,<a name="l00573"></a>00573 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)<a name="l00574"></a>00574 )<a name="l00575"></a>00575 <a name="l00576"></a>00576 OCI_ReleaseMetaString(ostr1);<a name="l00577"></a>00577 OCI_ReleaseMetaString(ostr2);<a name="l00578"></a>00578 <a name="l00579"></a>00579 OCI_RESULT(res);<a name="l00580"></a>00580 <a name="l00581"></a>00581 <span class="keywordflow">return</span> res;<a name="l00582"></a>00582 }<a name="l00583"></a>00583 <a name="l00584"></a>00584 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00585"></a>00585 <span class="comment"> * OCI_DateToCTime</span><a name="l00586"></a>00586 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00587"></a>00587 <a name="l00588"></a><a class="code" href="group__g__date.html#g52fb4405771971a2603e3eb871b3256e">00588</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g52fb4405771971a2603e3eb871b3256e" title="Affect an OCI_Date handle value to ISO C time datatypes.">OCI_DateToCTime</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keyword">struct</span> tm *ptm, time_t *pt)<a name="l00589"></a>00589 {<a name="l00590"></a>00590 time_t time = -1;<a name="l00591"></a>00591 <span class="keyword">struct </span>tm t;<a name="l00592"></a>00592 <a name="l00593"></a>00593 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00594"></a>00594 <a name="l00595"></a>00595 t.tm_year = date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateYYYY - 1900;<a name="l00596"></a>00596 t.tm_mon = date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateMM - 1;<a name="l00597"></a>00597 t.tm_mday = date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateDD;<a name="l00598"></a>00598 <a name="l00599"></a>00599 t.tm_hour = date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateTime.OCITimeHH;<a name="l00600"></a>00600 t.tm_min = date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateTime.OCITimeMI;<a name="l00601"></a>00601 t.tm_sec = date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateTime.OCITimeSS;<a name="l00602"></a>00602 <a name="l00603"></a>00603 t.tm_wday = 0;<a name="l00604"></a>00604 t.tm_yday = 0;<a name="l00605"></a>00605 t.tm_isdst = -1;<a name="l00606"></a>00606 <a name="l00607"></a>00607 time = mktime(&t);<a name="l00608"></a>00608 <a name="l00609"></a>00609 <span class="keywordflow">if</span> (ptm != NULL)<a name="l00610"></a>00610 memcpy(ptm, &t, <span class="keyword">sizeof</span>(t));<a name="l00611"></a>00611 <a name="l00612"></a>00612 <span class="keywordflow">if</span> (pt != NULL)<a name="l00613"></a>00613 *pt = time;<a name="l00614"></a>00614 <a name="l00615"></a>00615 OCI_RESULT(TRUE);<a name="l00616"></a>00616 <a name="l00617"></a>00617 <span class="keywordflow">return</span> (time != -1);<a name="l00618"></a>00618 }<a name="l00619"></a>00619 <a name="l00620"></a>00620 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00621"></a>00621 <span class="comment"> * OCI_DateFromCTime</span><a name="l00622"></a>00622 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00623"></a>00623 <a name="l00624"></a><a class="code" href="group__g__date.html#g5022740b8e062a289d7d06a2f5bd40ca">00624</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g5022740b8e062a289d7d06a2f5bd40ca" title="Affect ISO C time datatypes values to an OCI_Date handle.">OCI_DateFromCTime</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keyword">struct</span> tm *ptm, time_t t)<a name="l00625"></a>00625 {<a name="l00626"></a>00626 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00627"></a>00627 <a name="l00628"></a>00628 <span class="keywordflow">if</span> (ptm == NULL && t == 0)<a name="l00629"></a>00629 OCI_ExceptionNullPointer(OCI_IPC_TM);<a name="l00630"></a>00630 <a name="l00631"></a>00631 <span class="keywordflow">if</span> (ptm == NULL)<a name="l00632"></a>00632 ptm = localtime(&t);<a name="l00633"></a>00633 <a name="l00634"></a>00634 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateYYYY = (sb2) ptm->tm_year + 1900;<a name="l00635"></a>00635 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateMM = (ub1) ptm->tm_mon + 1;<a name="l00636"></a>00636 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateDD = (ub1) ptm->tm_mday;<a name="l00637"></a>00637 <a name="l00638"></a>00638 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateTime.OCITimeHH = (ub1) ptm->tm_hour;<a name="l00639"></a>00639 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateTime.OCITimeMI = (ub1) ptm->tm_min;<a name="l00640"></a>00640 date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>->OCIDateTime.OCITimeSS = (ub1) ptm->tm_sec;<a name="l00641"></a>00641 <a name="l00642"></a>00642 OCI_RESULT(TRUE);<a name="l00643"></a>00643 <a name="l00644"></a>00644 <span class="keywordflow">return</span> TRUE;<a name="l00645"></a>00645 }</pre></div><hr size="1"><address style="text-align: right;"><small>Generated on Thu Oct 9 10:07:42 2008 for OCILIB (C Driver for Oracle) by <a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.4 </small></address></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -