Re: [GENERAL] justify_interval: days in year

2014-11-10 Thread Ilya Ashchepkov
On Mon, 10 Nov 2014 14:14:15 +0100 Francisco Olarte wrote: > On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov > wrote: > > > Is this correct? > > $ select > > justify_interval(t-f-i) > > ,t-f-i > > from > > ( > > select > > timestamp '2014-1-1' as f, > > timestamp '2015-1

Re: [GENERAL] justify_interval: days in year

2014-11-10 Thread Francisco Olarte
On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov wrote: > 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|

[GENERAL] justify_interval: days in year

2014-11-10 Thread Ilya Ashchepkov
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:1