GROUP BY week query required

[sourabhjha]

I have table with a date field and a number field in it Can someone tell me the query by which i can fetch records is grouped by the week part of the date.

 

[stefanhei]

Try:
select to_char(yourDateField,'IW'),...

Stefan

 

[Prettyman]

Try group by to_char(sysdate,'YYYYIW') so that you can return grouped weekcode. MCSE/MCDBA
Testing OCP DBA 8i
******************

 

[sourabhjha]

suppose i want to compare my date field to lie between two given weeks (say 5th and 15th)then how do i do that.Remember that to_date("05 2001,'iw yyyy') won't work as to_date doesn't work for week formatting.