Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16169: Default time output for 24:00 is 00:00 - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #16169: Default time output for 24:00 is 00:00
Date
Msg-id 20191217181426.GA27596@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #16169: Default time output for 24:00 is 00:00  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16169: Default time output for 24:00 is 00:00  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Memory leak (possibly connected to postgis) leading to servercrash
Next
From: Tom Lane
Date:
Subject: Re: BUG #16169: Default time output for 24:00 is 00:00