Re: Get interval in months - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Get interval in months
Date
Msg-id 20081108125937.GA9668@tux
Whole thread Raw
In response to Get interval in months  (Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>)
List pgsql-general
Gerhard Heift <ml-postgresql-20081012-3518@gheift.de> schrieb:

> Hello,
>
> I want to get an interval in months from two dates:
>
> SELECT '2008-02-01'::timestamp - '2008-01-01'::timestamp AS '1 month'
>
> Here I want '1 month' and not '31 days' as answer.

How long is a month? 28 days? 31 days? But okay, i will try:

test=*# SELECT justify_days('2008-02-01'::timestamp - '2008-01-01'::timestamp) ;
 justify_days
--------------
 1 mon 1 day
(1 row)

Is this okay for you? PostgreSQL assume 30 days per month.



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: "David Spadea"
Date:
Subject: Re: Get interval in months
Next
From: Andreas Kretschmer
Date:
Subject: Re: grant privileges