给出一个日期,如何求出这个日期是该年该月的第几周

Question

select to_char(sysdate,'W') from dual;

Answer 1

select to_char(to_date('2003-05-18'),w) from dual

Answer 2

select to_char(to_date('2003-05-18','yyyy-mm-dd'),'w') from dual;

Answer 3

select to_char(to_date('20040821','yyyymmdd'),'W') from dual

Answer 4

SQL> select to_char(sysdate,'W') from dual;TO_CHAR(SYSDATE,'W')
--------------------
3SQL> select to_char(to_date('2004-11-16','yyyy-mm-dd'),'w') from dual;TO_CHAR(TO_DATE('2004-11-16','
------------------------------
3

Answer 5

日期和時間函數匯總
http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=198829

Answer 6

呵呵，补一下：
该月的第几周：select to_char(sysdate,'W') from dual;
该年的第几周：select to_char(sysdate,'WW') from dual;