📄 date_8c-source.html
字号:
<a name="l00260"></a>00260 <a name="l00261"></a>00261 OCI_CALL4<a name="l00262"></a>00262 (<a name="l00263"></a>00263 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="l00264"></a>00264 <a name="l00265"></a>00265 OCIDateCompare(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>, date2-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &value)<a name="l00266"></a>00266 )<a name="l00267"></a>00267 <a name="l00268"></a>00268 OCI_RESULT(res);<a name="l00269"></a>00269 <a name="l00270"></a>00270 <span class="keywordflow">return</span> (<span class="keywordtype">int</span>) value;<a name="l00271"></a>00271 }<a name="l00272"></a>00272 <a name="l00273"></a>00273 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00274"></a>00274 <span class="comment"> * OCI_DateDaysBetween</span><a name="l00275"></a>00275 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00276"></a>00276 <a name="l00277"></a><a class="code" href="group__g__date.html#gfa9f51e0977278bc43dafdef13d7fb5e">00277</a> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__date.html#gfa9f51e0977278bc43dafdef13d7fb5e" title="Return the number of days betWeen two dates.">OCI_DateDaysBetween</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date2)<a name="l00278"></a>00278 {<a name="l00279"></a>00279 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00280"></a>00280 sb4 nb = 0;<a name="l00281"></a>00281 <a name="l00282"></a>00282 OCI_CHECK_PTR(OCI_IPC_DATE, date, OCI_ERROR);<a name="l00283"></a>00283 OCI_CHECK_PTR(OCI_IPC_DATE, date2, OCI_ERROR);<a name="l00284"></a>00284 <a name="l00285"></a>00285 OCI_CALL4<a name="l00286"></a>00286 (<a name="l00287"></a>00287 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="l00288"></a>00288 <a name="l00289"></a>00289 OCIDateDaysBetween(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>, date2-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &nb)<a name="l00290"></a>00290 )<a name="l00291"></a>00291 <a name="l00292"></a>00292 OCI_RESULT(res);<a name="l00293"></a>00293 <a name="l00294"></a>00294 <span class="keywordflow">return</span> (sb4) nb;<a name="l00295"></a>00295 }<a name="l00296"></a>00296 <a name="l00297"></a>00297 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00298"></a>00298 <span class="comment"> * OCI_DateFromText</span><a name="l00299"></a>00299 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00300"></a>00300 <a name="l00301"></a><a class="code" href="group__g__date.html#ge0a2778f7c5646df7ea8748d7683b76b">00301</a> <span class="keywordtype">boolean</span> OCI_API <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>(<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 *str, <a name="l00302"></a>00302 <span class="keyword">const</span> mtext *fmt)<a name="l00303"></a>00303 {<a name="l00304"></a>00304 <span class="keywordtype">void</span> *ostr1 = NULL;<a name="l00305"></a>00305 <span class="keywordtype">void</span> *ostr2 = NULL;<a name="l00306"></a>00306 <span class="keywordtype">int</span> osize1 = -1;<a name="l00307"></a>00307 <span class="keywordtype">int</span> osize2 = -1;<a name="l00308"></a>00308 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00309"></a>00309 <a name="l00310"></a>00310 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00311"></a>00311 OCI_CHECK_PTR(OCI_IPC_STRING, str, FALSE);<a name="l00312"></a>00312 OCI_CHECK_PTR(OCI_IPC_STRING, fmt, FALSE);<a name="l00313"></a>00313 <a name="l00314"></a>00314 ostr1 = OCI_GetInputMetaString(str, &osize1);<a name="l00315"></a>00315 ostr2 = OCI_GetInputMetaString(fmt, &osize2);<a name="l00316"></a>00316 <a name="l00317"></a>00317 OCI_CALL4<a name="l00318"></a>00318 (<a name="l00319"></a>00319 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="l00320"></a>00320 <a name="l00321"></a>00321 OCIDateFromText(date-><a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>,<a name="l00322"></a>00322 (oratext *) ostr1, (ub4) osize1,<a name="l00323"></a>00323 (oratext *) ostr2, (ub1) osize2,<a name="l00324"></a>00324 (oratext *) NULL, (ub4) 0, date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)<a name="l00325"></a>00325 )<a name="l00326"></a>00326 <a name="l00327"></a>00327 OCI_ReleaseMetaString(ostr1);<a name="l00328"></a>00328 OCI_ReleaseMetaString(ostr2);<a name="l00329"></a>00329 <a name="l00330"></a>00330 OCI_RESULT(res);<a name="l00331"></a>00331 <a name="l00332"></a>00332 <span class="keywordflow">return</span> res;<a name="l00333"></a>00333 }<a name="l00334"></a>00334 <a name="l00335"></a>00335 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00336"></a>00336 <span class="comment"> * OCI_DateGetDate</span><a name="l00337"></a>00337 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00338"></a>00338 <a name="l00339"></a><a class="code" href="group__g__date.html#gdc1fad15bca1a1780d22148a104bcdbd">00339</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#gdc1fad15bca1a1780d22148a104bcdbd" title="Extract the date part from a date handle.">OCI_DateGetDate</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="l00340"></a>00340 {<a name="l00341"></a>00341 sb2 yr = 0;<a name="l00342"></a>00342 ub1 mt = 0;<a name="l00343"></a>00343 ub1 dy = 0;<a name="l00344"></a>00344 <a name="l00345"></a>00345 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00346"></a>00346 OCI_CHECK_PTR(OCI_IPC_INT, year, FALSE);<a name="l00347"></a>00347 OCI_CHECK_PTR(OCI_IPC_INT, month, FALSE);<a name="l00348"></a>00348 OCI_CHECK_PTR(OCI_IPC_INT, day, FALSE);<a name="l00349"></a>00349 <a name="l00350"></a>00350 *year = 0;<a name="l00351"></a>00351 *month = 0;<a name="l00352"></a>00352 *day = 0;<a name="l00353"></a>00353 <a name="l00354"></a>00354 OCIDateGetDate(date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &yr, &mt, &dy);<a name="l00355"></a>00355 <a name="l00356"></a>00356 *year = (int) yr;<a name="l00357"></a>00357 *month = (int) mt;<a name="l00358"></a>00358 *day = (int) dy;<a name="l00359"></a>00359 <a name="l00360"></a>00360 OCI_RESULT(TRUE);<a name="l00361"></a>00361 <a name="l00362"></a>00362 <span class="keywordflow">return</span> TRUE;<a name="l00363"></a>00363 }<a name="l00364"></a>00364 <a name="l00365"></a>00365 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00366"></a>00366 <span class="comment"> * OCI_DateGetTime</span><a name="l00367"></a>00367 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00368"></a>00368 <a name="l00369"></a><a class="code" href="group__g__date.html#ga20b12b698b3c244f7482aa0ed348be5">00369</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#ga20b12b698b3c244f7482aa0ed348be5" title="Extract the time part from a date handle.">OCI_DateGetTime</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="l00370"></a>00370 {<a name="l00371"></a>00371 ub1 hr = 0;<a name="l00372"></a>00372 ub1 mn = 0;<a name="l00373"></a>00373 ub1 sc = 0;<a name="l00374"></a>00374 <a name="l00375"></a>00375 OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00376"></a>00376 OCI_CHECK_PTR(OCI_IPC_INT, hour, FALSE);<a name="l00377"></a>00377 OCI_CHECK_PTR(OCI_IPC_INT, min , FALSE);<a name="l00378"></a>00378 OCI_CHECK_PTR(OCI_IPC_INT, sec, FALSE);<a name="l00379"></a>00379 <a name="l00380"></a>00380 *hour = 0;<a name="l00381"></a>00381 *min = 0;<a name="l00382"></a>00382 *sec = 0;<a name="l00383"></a>00383 <a name="l00384"></a>00384 OCIDateGetTime(date-><a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &hr, &mn, &sc);<a name="l00385"></a>00385 <a name="l00386"></a>00386 *hour = (int) hr;<a name="l00387"></a>00387 *min = (int) mn;<a name="l00388"></a>00388 *sec = (int) sc;<a name="l00389"></a>00389 <a name="l00390"></a>00390 OCI_RESULT(TRUE);<a name="l00391"></a>00391 <a name="l00392"></a>00392 <span class="keywordflow">return</span> TRUE;<a name="l00393"></a>00393 }<a name="l00394"></a>00394 <a name="l00395"></a>00395 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00396"></a>00396 <span class="comment"> * OCI_DateGetDateTime</span>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -