Search Postgresql Archives

justify_interval: days in year

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux