Обсуждение: Fwd: wrong timestamp

  --- the forwarded message follows ---
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.

В сообщении от 26 июля 2006 10:39 xyzyx написал(a):
>   --- the forwarded message follows ---
It is important to know that CURRENT_TIMESTAMP and related functions return
the start time of the current transaction; their values do not change during
the transaction
--
Kovalenko Oleg
ok@calculate.ru
http://www.calculate.ru
+7 812 336-36-32
+7 495 772-76-78