finding weeks between dates in oracle

From: jim agans <jwagans_at_yahoo.com>
Date: 13 Jun 2003 16:00:25 -0700
Message-ID: <82659da6.0306131500.50602a84@posting.google.com>

what I need to do is get the number of weeks between 2 dates and turn it into a decimal for adding to a sum and then getting the avg for the number of records read.

      I have 2 dates ex: 01/27/2000 and  09/22/1999
      how do it get the number of weeks in between....ie: 12.4
      I will then add the 12.4 to (sum_field) and read another record

and add 1 to a counter(rec_total)divide sum_field by records read(rec_count)

      say sum_field/ rec_count = 7.4 weeks

      I have looked at "between_months" but how do I convert it to weeks?

      thanks 
      jim agans

Received on Fri Jun 13 2003 - 18:00:25 CDT