ORACLE to_char() º¯Êý»ñÈ¡×ÔÈ»ÖÜÊý

 
×î¼òµ¥µÄÊÇʹÓÃ
 
/* Formatted on 2009/12/02 16:01 (Formatter Plus v4.8.8) */
SELECT TO_CHAR (TO_DATE ('2009-12-02', 'YYYY-MM-DD'), 'WW')
  from DUAL;
²»¹ýto_char()º¯ÊýÔÚ¼ÆËãÒ»ÄêÖеڼ¸ÖÜÊÇ´Ó¸ÃÄêµÄ1ÔÂ1ÈÕ¿ªÊ¼µÄ¡£
 
 ÒÔÏÂSQL Äܵõ½ÕýÈ·µÄ×ÔÈ»ÖÜÊý.
 
/* Formatted on 2009/12/02 15:31 (Formatter Plus v4.8.8) */
SELECT TO_CHAR
          (DECODE
              (SIGN
                  (  (  TO_DATE ('2009-12-02', 'YYYY-MM-DD')
                      + TO_NUMBER
                              (DECODE (TO_CHAR (TRUNC (TO_DATE ('2009-12-02',
                                                                'YYYY-MM-DD'
                                                               ),
                                &nb