wrong timestamp

From: xyzyx <xyzyx(at)rambler(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Subject: wrong timestamp
Date: 2006-07-25 13:54:00
Message-ID: 166696493.1153835640.168793320.41828@mcgi16.rambler.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wes 2006-07-25 13:55:55 Re: Lock changes with 8.1 - what's the right lock?
Previous Message Tom Lane 2006-07-25 13:41:42 Re: gmake Errors: pg_backup_archiver.c: undefined reference to `lo_create'