Problem displaying intervals and timestamps with pgAdmin 4
| От | Albe Laurenz |
|---|---|
| Тема | Problem displaying intervals and timestamps with pgAdmin 4 |
| Дата | |
| Msg-id | A737B7A37273E048B164557ADEF4A58B5385F029@ntex2010i.host.magwien.gv.at обсуждение исходный текст |
| Ответы |
Re: Problem displaying intervals and timestamps
with pgAdmin 4
|
| Список | pgadmin-support |
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
В списке pgadmin-support по дате отправления: