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