## Re: Calculating the number of months between two dates

From: elein(at)varlena(dot)com (elein) Brian Ghidinelli sfpug(at)postgresql(dot)org Re: Calculating the number of months between two dates 2005-08-28 19:03:06 20050828190306.GV21179@varlena.com (view raw or whole thread) 2005-08-26 02:06:02 from Brian Ghidinelli  2005-08-28 19:03:06 from elein(at)varlena(dot)com (elein) sfpug
```Look for the answer to this in tomorrow's General Bits.

http://www.varlena.com/GeneralBits

--elein

On Thu, Aug 25, 2005 at 07:06:02PM -0700, Brian Ghidinelli wrote:
>
> I'm having problems using timestamps and intervals to schedule recurring
> events.  How can I test if today's date/timestamp is equal to a start
> date plus some number of arbitrary intervals?  E.g., 3/30/05 + (X * 2
> months) = 5/30, 7/30, 9/30, etc.
>
> The main problem I'm having is that subtracting timestamps always
> results in an interval of days rather than some combination of years,
> months, days, etc.
>
> Thanks for any pointers or ideas,
>
>
> Brian
>

```

### sfpug by date

 Next: From: Josh Berkus Date: 2005-08-30 18:07:19 Subject: Next Meeting -- Sept. 14 Previous: From: Brian Ghidinelli Date: 2005-08-26 02:06:02 Subject: Calculating the number of months between two dates