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...
