Postgres Pro
Downloads
Home   >   mailing lists

wrong timestamp - Mailing list pgsql-general

From xyzyx
Subject wrong timestamp
Date
Msg-id 166696493.1153835640.168793320.41828@mcgi16.rambler.ru
Whole thread Raw
Responses Re: wrong timestamp  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
Hello,
I use Postgresql 8.1.4 on Debian,
when I run command 'select current timestamp' or 'select now'  in
pgAdmin, I everytime get "2000-01-01 03:02:16.105976+03".
When I run 'select TIMEOFDAY()' I get right time.

Whats wrong?
--
xyzyx.

pgsql-general by date:

Previous
From: "chris997"
Date:
Subject: Re: "Ghost" colmumn with primary key
Next
From: Kenneth Downs
Date:
Subject: Re: loop with circular updates