justify_interval: days in year

From: Ilya Ashchepkov <koctep(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: justify_interval: days in year
Date: 2014-11-10 09:07:48
Message-ID: 20141110150748.2ee99776@moni.nskavd.local
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

Is this correct?
$ select
justify_interval(t-f-i)
,t-f-i
from
(
select
timestamp '2014-1-1' as f,
timestamp '2015-1-1' as t,
interval '06:49:00' as i
) S;

justify_interval | ?column?
------------------------+--------------------
1 year 4 days 17:11:00 | 365 days -06:49:00

Why do we have 360 days in a year?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jehan-Guillaume de Rorthais 2014-11-10 10:52:54 Strange avg value size for index on expression in pg_stats
Previous Message Tatsuo Ishii 2014-11-10 03:25:38 Re: Query Plans on Slaves