I have PostgreSQL 9.5.0 and I observe strange interval values returned by very similar queries. I thought that then interval is bigger than 24 hours then it is returned with days
part like this:
SELECT (1000 * ('2016-02-04 12:00:11'::timestamp - '2016-02-03 12:00:00'::timestamp)::interval)::interval
1000 days 03:03:20
But sometimes hours are not converted to days:
SELECT (1000 * ('2016-02-04 11:00:11'::timestamp - '2016-02-03 12:00:00'::timestamp)::interval)::interval
23003:03:20
How can I force the same output format with days part?