Re: Get interval in months
От | Andreas Kretschmer |
---|---|
Тема | Re: Get interval in months |
Дата | |
Msg-id | 20081108125937.GA9668@tux обсуждение исходный текст |
Ответ на | Get interval in months (Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>) |
Список | 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 по дате отправления: