Thread: Date/time problem

Date/time problem

From
Oleg Broytmann
Date:
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.