Hello!
I falled into problem.
test=> select datetime(current_date, '11:00'::time);
datetime
----------------------------
Fri 20 Nov 17:00:00 1998 MSK
(1 row)
It is 6 hours off! (I want 11:00 here). Ok, I understand what is going
on: 6 hours = 2*3, where 3 is MSK offset (MSK = GMT + 3).
I got this on debian and redhat linux boxes. On Solaris it's Ok - 11:00.
Looks like timezone problem in libc. How can I solve this? I have
compiled timezone on 3 computers (redhat, debian, solaris) from the same
timezone.src.
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.