oracleÈÕÆÚº¯Êý¼¯½õ
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from dual;
TO_CHAR(SYSDATE,'YYY')
----------------------
007
2.Q ¼¾¶È 1¡«3ÔÂΪµÚÒ»¼¾¶È£¬2±íʾµÚ¶þ¼¾¶È¡£
SQL> Select to_char(sysdate,'Q') from dual;
TO_CHAR(SYSDATE,'Q')
--------------------
2
3.MM Ô·ÝÊý
SQL> Select to_char(sysdate,'MM') from dual;
TO_CHAR(SYSDATE,'MM')
---------------------
05
4.RM Ô·ݵÄÂÞÂí±íʾ £¨VÔÚÂÞÂíÊý×ÖÖбíʾ 5£©
SQL> Select to_char(sysdate,'RM') from dual;
TO_CHAR(SYSDATE,'RM')
---------------------
V
5.Month ÓÃ9¸ö×Ö·û³¤¶È±íʾµÄÔ·ÝÃû
SQL> Select to_char(sysdate,'Month') from dual;
TO_CHAR(SYSDATE,'MONTH')
------------------------
5ÔÂ
6.WW µ±ÄêµÚ¼¸ÖÜ £¨2007Äê5ÔÂ29ÈÕΪ2007ÄêµÚ22ÖÜ£©
SQL> Select to_char(sysdate,'WW') from dual;
TO_CHAR(SYSDATE,'WW')
---------------------
22
7.W ±¾Ôµڼ¸ÖÜ £¨2007Äê5ÔÂ29ÈÕΪ5ÔµÚ5ÖÜ£©
SQL> Select to_char(sysdate,'W') from dual;
TO_CHAR(SYSDATE,'W')
--------------------
5
8.DDD µ±ÄêµÚ¼¸Ìì £¨2007Äê5ÔÂ29ÈÕΪ2007ÄêµÚ149Ì죩
SQL> Select to_char(sysdate,'DDD') from dual;
TO_CHAR(SYSDATE,'DDD')
----------------------
149
9. DD µ±Ôµڼ¸Ìì
SQL> Select to_char(sysdate,'DD') from dual;
TO_CHAR(SYSDATE,'DD')
---------------------
29
10.D ÖÜÄÚµÚ¼¸Ìì
SQL> Select to_char(sysdate,'D') from dual;
TO_CHAR(SYSDATE,'D')
--------------------
3
11.DY ÖÐÎĵÄÐÇÆÚ¼¸ £¨ £¨2007Äê5ÔÂ29ÈÕΪÐÇÆÚ¶þ£©£©
SQL> Select to_char(sysdate,'DY') from dual;
TO_CHAR(SYSDATE,'DY')
---------------------
ÐÇÆÚ¶þ
12.HH»òHH12 12½øÖÆÐ¡Ê±Êý £¨16£º09·ÖΪÓÃ12Ð¡Ê±ÖÆ¼ÆÊ±Îª4µã£©
SQL> Select to_char(sysdate,'HH') from dual;
TO_CHAR(SYSDATE,'HH')
---------------------
04
13.HH24 24Ð¡Ê±ÖÆ
SQL> Select to_char(sysdate,'HH24') from dual;
TO_CHAR(SYSDATE,'HH24')
-----------------------
Ïà¹ØÎĵµ£º
³éÏóÊý¾ÝÀàÐÍ£¬ÈÃOracleÊý¾Ý¿âÊý¾Ý¹ÜÀí¸ü¼ÓÈÝÒ×
×÷Õß: Victor, ¡¡³ö´¦:ITר¼ÒÍø,¡¡ÔðÈαà¼: °ü´ºÁÖ,¡¡
2009-02-04 10:10
¡¡¡¡ÐÕÃû£¬Æäʵ°üÀ¨Á½¸ö²¿·Ö£¬·Ö±ðΪÐÕÓëÃû¡£ÔÚûÓгéÏóÊý¾ÝÀàÐÍ֮ǰ£¬ÔÚÊý¾Ý¿âÉè¼ÆµÄʱºò£¬ÍùÍùÐèÒªÀûÓÃÁ½¸ö×Ö¶ÎÀ´±£´æÕâ¸öÐÕÃûÄÚÈÝ£¬ÈçFirst_nameÓëLast_nameµÈµÈ¡£ÕâÖ÷ÒªÊÇÒòΪÔںܶàʱºò£¬Ç°Ì¨ ......
OracleÆóÒµ¹ÜÀíÆ÷11gÌṩҵ½ç×îÈ«ÃæµÄÒµÎñÇý¶¯ÐÍIT¹ÜÀí¹¦ÄÜ£¬ÓÐÖúÓÚͨ¹ý¼¯³ÉʽIT¹ÜÀí·½·¨£¬×î´óÏ޶ȵØÌá¸ßÆóÒµÃô½ÝÐÔºÍЧÂÊ¡£
¡¡¡¡OracleÆóÒµ¹ÜÀíÆ÷11gÒýÈëÁË£º
¡¡¡¡ÒµÎñÇý¶¯ÐÍÓ¦ÓùÜÀí - ʹITϵͳÄܹ»¸ü¿ìµØÏìÓ¦ÓÅÏÈÒµÎñ£¬Í¨¹ý¹ÜÀíÃæÏòÓû§ÌåÑéºÍÉÌÎñ½»Ò׵ĹؼüÖ¸±ê£¬Ìṩ¸ü¸ßµÄÉÌÒµ¼ÛÖµ¡£
¡¡¡¡¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀ ......
¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀí£¬¼ò»¯¹ÜÀí»·¾³£¬Ìá¸ßͶ×ʻر¨ÂÊ
¡¡¡¡È«Ãæ¹ÜÀíOracleµÄ²úÆ·£¬°üÀ¨Äܹ»¹ÜÀíOracleÓ¦ÓÃÈí¼þ¡¢OracleÈÚºÏÖмä¼þ¡¢OracleÊý¾Ý¿â¡¢Oracle Solaris¡¢OracleÆóÒµ¼¶Linux¡¢Oracle VMºÍOracle Sun·þÎñÆ÷µÄ¹¤¾ß¡£ÕâʹµÃITÄܹ»¿ìËÙÈ·¶¨ÎÊÌâµÄ¸ù±¾ÔÒò£¬¶øÇÒÔںܶàÇé¿öÏ£¬»¹ÄÜ×Ô¶¯µØ½â¾öÎÊÌâ¡£
¡¡¡¡ÁíÍ⣬Õâ ......
Oracle°æ±¾µÄÇø±ðÓÐÄÇЩ
http://database.51cto.com/art/201004/196494.htm
http://database.51cto.com
2010-04-23 15:20 ØýÃû »¥ÁªÍø ÎÒÒªÆÀÂÛ(
0
)
ͻ񻣼
ÒÔϵÄÎÄÕÂÖ÷ÒªÊǶÔOracle°æ±¾µÄÇø±ðµÄ¼òÊö£¬Èç¹ûÄã¶ÔÆäµÄÏà¹ØÄÚÈݸÐÐËȤµÄ
»°£¬ÒÔϵÄÎÄÕÂÖ÷Òª¾ÍÊÇ¶ÔÆäÏà¹ØÄÚÈÝµÄ ......