Date / interval question

Поиск
Список
Период
Сортировка
От kevin kempter
Тема Date / interval question
Дата
Msg-id AAD89495-0184-42F0-9ABB-DB2C2E26D429@kevinkempterllc.com
обсуждение исходный текст
Ответы Re: Date / interval question
Re: Date / interval question
Список pgsql-general
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...


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: pgcrypto and dblink
Следующее
От: J Ottery
Дата:
Сообщение: Postgres on shared network drive