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°