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

[sifinc]

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

比如:2004-11-1是11月的第一周.
2003-05-18是2003年5月的第几周呢?
用PL/SQL如何写出来?

[ylhyh]

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

[qiaozhiwei]

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

[YuriOU]

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

[bluelamb]

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

[zwj0712]

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

[hzf005]

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

TO_CHAR(SYSDATE,'W')
--------------------
3

SQL> select to_char(to_date('2004-11-16','yyyy-mm-dd'),'w') from dual;

TO_CHAR(TO_DATE('2004-11-16','
------------------------------
3

[baojianjun]

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