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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to