Answer the question
In order to leave comments, you need to log in
Ubuntu, postgres, pgadmin, BC date, why?
Hi.
local machine. Ubuntu 14.04. postgresql 9.3
I get data from the database through pgadmin, and the dates are not displayed correctly there, they are BC.
Before the time change it was "0001-01-01 00:00:00+02:30:20
"
Can you please tell me where it can be not completed?
ubuntu 14.04
$date
Wed oct. 29 11:24:06 MSK 2014
$ cat /etc/timezone
Europe/Moscow
$ psql
postgres=#show timezone;
TimeZone
---------------
W-SU
(1 row)
thanks in advance
Answer the question
In order to leave comments, you need to log in
Why do you think it's wrong? Your dates are the same, just the time zone has shifted by 3 seconds.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question