Date / interval question

[kevin kempter <kevin@xxxxxxxxxxxxxxxxxxx>]

Hi List;

I'm populating a time dimension. I need to get the number of days  
since the start of the fiscal year and also the number of months since  
the start of the fiscal year based on the current 'date' being  
processed.

Example:

my current process date is 01/01/2007
start date of fiscal year is 09/01/2006

I can get the number of days since the start of the fiscal year like  
this:

# select date '01/01/2007' -  date '09/01/2006' as interval;
 interval
----------
      122
(1 row)

However I'm stumped [er how to get the number of months from  
09/01/2007 thru 01/01/2007

Thoughts ?

Thanks in advance...