Re: BUG #16169: Default time output for 24:00 is 00:00

Alvaro Herrera <[email protected]> Tue, 17 Dec 2019 15:14:26 -0300

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<[email protected]>

On 2019-Dec-17, Tom Lane wrote:

> However ... when you run it on sqlfiddle, that shows the 't' column as
> 00:00:00 in both cases.  It also shows the fourth column in a format
> that doesn't match any of our intervalstyle formats.

Hm, interesting.  SELECT version() in sqlfiddle's postgres 9.6 says:

PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit

As I remember, EDB would be visible.

-- 
Ãlvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services