用sql语句得到指定日期所在的周是本年度第几周（Specify the date where the annual week was the first few weeks with the SQL statement）.docVIP

用sql语句得到指定日期所在的周是本年度第几周（Specify the date where the annual week was the first few weeks with the SQL statement） Specify the date where the annual week was the first few weeks with the SQL statement Personal classification: SQL skills Yesterday, a customer demand, demand has to be used for the specified date in the week was the year of the first few weeks Seeing this question, I naturally think of the use of to_char (D,ww): SQL, select, date2010-01-1+ rownum - 1 r, 2 to_char (date2010-01-1+ rownum - 1,d) -1 wn, 3 to_number (to_char (date2010-01-1+ rownum - 1,ww)) nthweek 4 from dual 5 connect by