Dear Friends,
I have two conditions , i am finding some difficulties in getting these things done
1) I have two dates (say 5-Aug-2013 and 26-Aug-2013) , both the dates are falling on Mondays.
My objective is to find the number of weeks between these two dates
i can just think of
{code} select (to_Date('26-Aug-2013') - to_date('5-Aug-2013')) /7 from dual {code}
2) I need to find the total number of weeks in the last 3 months based on a date ( Say if date is 4-Jul-2013, then the previous months will be Jul,Jun And May, Now total number of weeks for these three months based on 4-5-4 logic)
?????????
AbhSheikh