how to separate month into week in sql
759148Mar 25 2010 — edited Mar 25 2010hello, all
i have to question in this forum. How to separe month into week in sql. Example:::
when i choosen date between to_date('1/03/2010', 'dd/MM/yyyy') and to_date('28/03/2010', 'dd/MM/yyyy') . how can I know that between that date is in week number?? Week 9 or week 10. How to do that in sql.. Thanks for your help.
select * from daily_visit_kgaransi A,REF_TOKO C
where a.tgl_visit between to_date('1/03/2010', 'dd/MM/yyyy')
and to_date('28/03/2010', 'dd/MM/yyyy')
AND substr(a.svm_id,1,10)=C.ID