ÉèΪÊ×Ò³ ¼ÓÈëÊÕ²Ø

TOP

ORACLE¶¨Ê±Ö´Ðд洢¹ý³Ì³£ÓÃʱ¼ä¼ä¸ô
2015-07-24 10:52:22 À´Ô´: ×÷Õß: ¡¾´ó ÖРС¡¿ ä¯ÀÀ:1´Î
Tags£ºORACLE ¶¨Ê± Ö´ÐÐ ´æ´¢ ¹ý³Ì ³£Óà ʱ¼ä ¼ä¸ô

1:ÿ·ÖÖÓÖ´ÐÐ

Interval => TRUNC(sysdate,'mi') + 1/ (24*60)

»ò

Interval => sysdate+1/1440

2:ÿÌ춨ʱִÐÐ

ÀýÈ磺ÿÌìµÄÁ賿1µãÖ´ÐÐ

Interval => TRUNC(sysdate) + 1 +1/ (24)

3:ÿÖܶ¨Ê±Ö´ÐÐ

ÀýÈ磺ÿÖÜÒ»Á賿1µãÖ´ÐÐ

Interval => TRUNC(next_day(sysdate,'ÐÇÆÚÒ»'))+1/24

4:ÿÔ¶¨Ê±Ö´ÐÐ

ÀýÈ磺ÿÔÂ1ÈÕÁ賿1µãÖ´ÐÐ

Interval =>TRUNC(LAST_DAY(SYSDATE))+1+1/24

5:ÿ¼¾¶È¶¨Ê±Ö´ÐÐ

ÀýÈçÿ¼¾¶ÈµÄµÚÒ»ÌìÁ賿1µãÖ´ÐÐ

Interval => TRUNC(ADD_MONTHS(SYSDATE,3),'Q') + 1/24

6:ÿ°ëÄ궨ʱִÐÐ

ÀýÈ磺ÿÄê7ÔÂ1ÈÕºÍ1ÔÂ1ÈÕÁ賿1µã

Interval => ADD_MONTHS(trunc(sysdate,'yyyy'),6)+1/24

7:ÿÄ궨ʱִÐÐ

ÀýÈ磺ÿÄê1ÔÂ1ÈÕÁ賿1µãÖ´ÐÐ

Interval =>ADD_MONTHS(trunc(sysdate,'yyyy'),12)+1/24

¡¾´ó ÖРС¡¿¡¾´òÓ¡¡¿ ¡¾·±Ìå¡¿¡¾Í¶¸å¡¿¡¾Êղء¿ ¡¾ÍƼö¡¿¡¾¾Ù±¨¡¿¡¾ÆÀÂÛ¡¿ ¡¾¹Ø±Õ¡¿ ¡¾·µ»Ø¶¥²¿¡¿
·ÖÏíµ½: 
ÉÏһƪ£ºMongoDB4.6.1c++driver±àÒë ÏÂһƪ£º¶ÁxmlÉú³É´úÂëÀý×Ó

ÆÀÂÛ

ÕÊ¡¡¡¡ºÅ: ÃÜÂë: (ÐÂÓû§×¢²á)
Ñé Ö¤ Âë:
±í¡¡¡¡Çé:
ÄÚ¡¡¡¡ÈÝ:

¡¤Linuxϵͳ¼ò½é (2025-12-25 21:55:25)
¡¤Linux°²×°MySQL¹ý³Ì (2025-12-25 21:55:22)
¡¤Linuxϵͳ°²×°½Ì³Ì£¨ (2025-12-25 21:55:20)
¡¤HTTP Åc HTTPS µÄ²î„ (2025-12-25 21:19:45)
¡¤ÍøÕ¾°²È«±ØÐ޿ΣºÍ¼ (2025-12-25 21:19:42)