Thread: pgAdmin4 v2.0 does not display time value 24:00:00

pgAdmin4 v2.0 does not display time value 24:00:00

From
Date:

The data grid in pgAdmin4 does not display the correct value if a column with datatype time has the value 24:00  :

 

Query:  select '24:00'::time, '24:00'::time::text

Result:  '00:00:00','24:00:00'

 

pgAdmin3 shows the correct values:

Result:  '24:00:00','24:00:00'

 

Regards

Harald Immerheiser

 

Re: pgAdmin4 v2.0 does not display time value 24:00:00

From
Murtuza Zabuawala
Date:
Thanks for reporting.

On Thu, Nov 16, 2017 at 11:31 PM, <Harald.Immerheiser@ruv.de> wrote:

The data grid in pgAdmin4 does not display the correct value if a column with datatype time has the value 24:00  :

 

Query:  select '24:00'::time, '24:00'::time::text

Result:  '00:00:00','24:00:00'

 

pgAdmin3 shows the correct values:

Result:  '24:00:00','24:00:00'

 

Regards

Harald Immerheiser