pgAdmin4 v2.0 does not display time value 24:00:00 - Mailing list pgadmin-support

From
Subject pgAdmin4 v2.0 does not display time value 24:00:00
Date
Msg-id EB2A486225C4584FA62A22C75AEBB454826D43F3@RUV.DE
Whole thread Raw
Responses Re: pgAdmin4 v2.0 does not display time value 24:00:00  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
List pgadmin-support

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

 

pgadmin-support by date:

Previous
From: George Weaver
Date:
Subject: Re: Windows testing required: Updated runtime
Next
From: Murtuza Zabuawala
Date:
Subject: Re: pgAdmin4 v2.0 does not display time value 24:00:00