Re: Problem displaying intervals and timestamps with pgAdmin 4 - Mailing list pgadmin-support

From Dave Page
Subject Re: Problem displaying intervals and timestamps with pgAdmin 4
Date
Msg-id CA+OCxoyCUy93cfNNM-iBxkuW4vTMQ73_Qdh5aAS-niYJrFd8Pw@mail.gmail.com
Whole thread Raw
In response to Problem displaying intervals and timestamps with pgAdmin 4  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: Problem displaying intervals and timestamps with pgAdmin 4  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgadmin-support
Thanks - issue #1352 created.

Please log any additional issues directly at
https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me
a step :-)



On Mon, Jun 13, 2016 at 10:32 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> I am using pgAdmin 4 1.0-beta1 (downloaded from pgadmin.org) on Windows 7.
>
> I get an error message like this:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
> <title>500 Internal Server Error</title>
> <h1>Internal Server Error</h1>
> <p>The server encountered an internal error and was unable to complete your request.  Either the server is overloaded
orthere is an error in the application.</p>
 
>
> When I SELECT any interval or a date/timestamp/timestamptz value before Christ.
>
> Examples:
>
>   SELECT DATE '0044-03-15 BC';
>
>   SELECT TIMESTAMP '0044-03-15 10:00:00 BC';
>
>   SELECT TIMESTAMPTZ '0044-03-15 10:00:00+02 BC';
>
>   SELECT INTERVAL '15 minutes';
>
> Also, when displaying a timestamptz value, the time part gets lost:
>
>   SELECT TIMESTAMPTZ '2016-03-15 10:00:00+02 AD';
> displays
>   2016-03-15T00:00:00Z
>
> Yours,
> Laurenz Albe
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgadmin-support by date:

Previous
From: Albe Laurenz
Date:
Subject: Problem displaying intervals and timestamps with pgAdmin 4
Next
From: Albe Laurenz
Date:
Subject: Re: Problem displaying intervals and timestamps with pgAdmin 4