📄 timestamp_8c-source.html
字号:
<a name="l00586"></a>00586 OCI_NOT_USED(hour);<a name="l00587"></a>00587 OCI_NOT_USED(min);<a name="l00588"></a>00588 OCI_NOT_USED(sec);<a name="l00589"></a>00589 OCI_NOT_USED(fsec);<a name="l00590"></a>00590 OCI_NOT_USED(hr);<a name="l00591"></a>00591 OCI_NOT_USED(mn);<a name="l00592"></a>00592 OCI_NOT_USED(sc);<a name="l00593"></a>00593 OCI_NOT_USED(fs);<a name="l00594"></a>00594 <a name="l00595"></a>00595 <span class="preprocessor">#endif</span><a name="l00596"></a>00596 <span class="preprocessor"></span><a name="l00597"></a>00597 OCI_RESULT(res);<a name="l00598"></a>00598 <a name="l00599"></a>00599 <span class="keywordflow">return</span> res;<a name="l00600"></a>00600 }<a name="l00601"></a>00601 <a name="l00602"></a>00602 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00603"></a>00603 <span class="comment"> * OCI_TimestampGetDateTime</span><a name="l00604"></a>00604 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00605"></a>00605 <a name="l00606"></a><a class="code" href="group__g__timestamp.html#g364aa28b777ed77ac6c66b7dd95926e8">00606</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#g364aa28b777ed77ac6c66b7dd95926e8" title="Extract the date and time parts from a date handle.">OCI_TimestampGetDateTime</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> *tmsp, <span class="keywordtype">int</span> *year, <a name="l00607"></a>00607 <span class="keywordtype">int</span> *month, <span class="keywordtype">int</span> *day, <span class="keywordtype">int</span> *hour, <a name="l00608"></a>00608 <span class="keywordtype">int</span> *min, <span class="keywordtype">int</span> *sec, <span class="keywordtype">int</span> *fsec)<a name="l00609"></a>00609 {<a name="l00610"></a>00610 <span class="keywordflow">return</span> (<a class="code" href="group__g__timestamp.html#ge8b95bad27ed1bce2e9753e30d3fa26b" title="Extract the date part from a timestamp handle.">OCI_TimestampGetDate</a>(tmsp, year, month, day) &&<a name="l00611"></a>00611 <a class="code" href="group__g__timestamp.html#g4c56996d6dc31b7a4373daa0018c88e1" title="Extract the time portion from a timestamp handle.">OCI_TimestampGetTime</a>(tmsp, hour, min, sec, fsec));<a name="l00612"></a>00612 }<a name="l00613"></a>00613 <a name="l00614"></a>00614 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00615"></a>00615 <span class="comment"> * OCI_TimestampGetTimeZoneName</span><a name="l00616"></a>00616 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00617"></a>00617 <a name="l00618"></a><a class="code" href="group__g__timestamp.html#gc118f3649052c1460ac309abd2f7e2ba">00618</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#gc118f3649052c1460ac309abd2f7e2ba" title="Return the time zone name of a timestamp handle.">OCI_TimestampGetTimeZoneName</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> *tmsp, <span class="keywordtype">int</span> size,<a name="l00619"></a>00619 mtext *str)<a name="l00620"></a>00620 {<a name="l00621"></a>00621 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00622"></a>00622 <span class="keywordtype">void</span> *ostr = NULL;<a name="l00623"></a>00623 <span class="keywordtype">int</span> osize = size*<span class="keyword">sizeof</span>(mtext);<a name="l00624"></a>00624 <a name="l00625"></a>00625 OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp, FALSE);<a name="l00626"></a>00626 OCI_CHECK_PTR(OCI_IPC_STRING, str, FALSE);<a name="l00627"></a>00627 <a name="l00628"></a>00628 OCI_CHECK_TIMESTAMP_ENABLED(tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, FALSE);<a name="l00629"></a>00629 <a name="l00630"></a>00630 <span class="preprocessor">#if OCI_VERSION_COMPILE >= OCI_9</span><a name="l00631"></a>00631 <span class="preprocessor"></span><a name="l00632"></a>00632 ostr = OCI_GetInputMetaString(str, &osize);<a name="l00633"></a>00633 <a name="l00634"></a>00634 OCI_CALL4<a name="l00635"></a>00635 (<a name="l00636"></a>00636 res, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>,<a name="l00637"></a>00637 <a name="l00638"></a>00638 OCIDateTimeGetTimeZoneName((dvoid *) OCILib.env, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>,<a name="l00639"></a>00639 (ub1*) ostr, (ub4*) &osize)<a name="l00640"></a>00640 )<a name="l00641"></a>00641 <a name="l00642"></a>00642 OCI_GetOutputMetaString(ostr, str, &osize);<a name="l00643"></a>00643 <a name="l00644"></a>00644 OCI_ReleaseMetaString(ostr);<a name="l00645"></a>00645 <a name="l00646"></a>00646 <span class="comment">/* set null string terminator */</span><a name="l00647"></a>00647 <a name="l00648"></a>00648 str[osize/<span class="keyword">sizeof</span>(mtext)] = 0;<a name="l00649"></a>00649 <a name="l00650"></a>00650 <span class="preprocessor">#else</span><a name="l00651"></a>00651 <span class="preprocessor"></span><a name="l00652"></a>00652 OCI_NOT_USED(str);<a name="l00653"></a>00653 OCI_NOT_USED(size);<a name="l00654"></a>00654 OCI_NOT_USED(ostr);<a name="l00655"></a>00655 OCI_NOT_USED(osize);<a name="l00656"></a>00656 <a name="l00657"></a>00657 <span class="preprocessor">#endif</span><a name="l00658"></a>00658 <span class="preprocessor"></span><a name="l00659"></a>00659 OCI_RESULT(res);<a name="l00660"></a>00660 <a name="l00661"></a>00661 <span class="keywordflow">return</span> res;<a name="l00662"></a>00662 }<a name="l00663"></a>00663 <a name="l00664"></a>00664 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00665"></a>00665 <span class="comment"> * OCI_TimestampGetTimeZoneOffset</span><a name="l00666"></a>00666 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00667"></a>00667 <a name="l00668"></a><a class="code" href="group__g__timestamp.html#g807ca5a3e663b234945f9a018e88badb">00668</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#g807ca5a3e663b234945f9a018e88badb" title="Return the time zone (hour, minute) portion of a timestamp handle.">OCI_TimestampGetTimeZoneOffset</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> *tmsp,<a name="l00669"></a>00669 <span class="keywordtype">int</span> *hour, <span class="keywordtype">int</span> *min)<a name="l00670"></a>00670 {<a name="l00671"></a>00671 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00672"></a>00672 <a name="l00673"></a>00673 OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp, FALSE);<a name="l00674"></a>00674 OCI_CHECK_PTR(OCI_IPC_INT, hour, FALSE);<a name="l00675"></a>00675 OCI_CHECK_PTR(OCI_IPC_INT, min, FALSE);<a name="l00676"></a>00676 <a name="l00677"></a>00677 OCI_CHECK_TIMESTAMP_ENABLED(tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, FALSE);<a name="l00678"></a>00678 <a name="l00679"></a>00679 <span class="preprocessor">#if OCI_VERSION_COMPILE >= OCI_9</span><a name="l00680"></a>00680 <span class="preprocessor"></span><a name="l00681"></a>00681 OCI_CALL4<a name="l00682"></a>00682 (<a name="l00683"></a>00683 res, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>,<a name="l00684"></a>00684 <a name="l00685"></a>00685 OCIDateTimeGetTimeZoneOffset((dvoid *) OCILib.env, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>,<a name="l00686"></a>00686 tmsp-><a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>, (sb1*) hour, (sb1*) min)<a name="l00687"></a>00687 )<a name="l00688"></a>00688 <a name="l00689"></a>00689 <span class="preprocessor">#else</span><a name="l00690"></a>00690 <span class="preprocessor"></span><a name="l00691"></a>00691 OCI_NOT_USED(hour);<a name="l00692"></a>00692 OCI_NOT_USED(min);<a name="l00693"></a>00693 <a name="l00694"></a>00694 <span class="preprocessor">#endif</span><a name="l00695"></a>00695 <span class="preprocessor"></span><a name="l00696"></a>00696 OCI_RESULT(res);<a name="l00697"></a>00697 <a name="l00698"></a>00698 <span class="keywordflow">return</span> res;<a name="l00699"></a>00699 }<a name="l00700"></a>00700 <a name="l00701"></a>00701 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00702"></a>00702 <span class="comment"> * OCI_TimestampIntervalAdd</span><a name="l00703"></a>00703 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00704"></a>00704 <a name="l00705"></a><a class="code" href="group__g__timestamp.html#g43028a0463f25bcd9665993a244572e7">00705</a> <span class="keywordtype">boolean</span> OCI_API <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>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> *tmsp, <a class="code" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> *itv)<a name="l00706"></a>00706 {<a name="l00707"></a>00707 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00708"></a>00708 <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> *tmp = NULL;<a name="l00709"></a>00709 <a name="l00710"></a>00710 OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp, FALSE);<a name="l00711"></a>00711 OCI_CHECK_PTR(OCI_IPC_INTERVAL, itv, FALSE);<a name="l00712"></a>00712 <a name="l00713"></a>00713 OCI_CHECK_TIMESTAMP_ENABLED(tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, FALSE);<a name="l00714"></a>00714 <a name="l00715"></a>00715 <span class="preprocessor">#if OCI_VERSION_COMPILE >= OCI_9</span><a name="l00716"></a>00716 <span class="preprocessor"></span><a name="l00717"></a>00717 <span class="comment">/* OCIDateTimeIntervalAdd() fails if timestamps is not OCI_TIMESTAMP_TZ */</span><a name="l00718"></a>00718 <a name="l00719"></a>00719 <span class="keywordflow">if</span> ((res == TRUE) && (tmsp-><a class="code" href="struct_o_c_i___timestamp.html#c650d324d802e3484654ec52df509ff5">type</a> != OCI_TIMESTAMP_TZ)) <a name="l00720"></a>00720 {<a name="l00721"></a>00721 tmp = <a class="code" href="group__g__timestamp.html#g5c590ea371920703997cd7bea126ad9d" title="Create a local Timestamp instance.">OCI_TimestampCreate</a>(tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, OCI_TIMESTAMP_TZ);<a name="l00722"></a>00722 <a name="l00723"></a>00723 res = <a class="code" href="group__g__timestamp.html#g7eec8396448c7466944fd37d7386bc89" title="Convert one timestamp value from one type to another.">OCI_TimestampConvert</a>(tmp, tmsp);<a name="l00724"></a>00724 }<a name="l00725"></a>00725 <span class="keywordflow">else</span><a name="l00726"></a>00726 tmp = tmsp;<a name="l00727"></a>00727 <a name="l00728"></a>00728 OCI_CALL4<a name="l00729"></a>00729 (<a name="l00730"></a>00730 res, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-><a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>,<a name="l00731"></a>00731 <a name="l00732"></a>00732 OCIDateTimeIntervalAdd((dvoid *) OCILib.env, tmp-><a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmp-><a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>,<a name="l00733"></a>00733 itv-><a class="code" href="struct_o_c_i___interval.html#84c681371⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -