I
I
Ilnur Gaifutdinov2014-10-29 11:42:01
PostgreSQL
Ilnur Gaifutdinov, 2014-10-29 11:42:01

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

2 answer(s)
P
Power, 2014-10-29
@Power

Why do you think it's wrong? Your dates are the same, just the time zone has shifted by 3 seconds.

I
Ilnur Gaifutdinov, 2014-10-29
@ilnurgi

apt-get update
apt-get upgrade
done, problem still there

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question