| From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Date/time problem |
| Date: | 1998-11-20 16:20:10 |
| Message-ID: | Pine.SOL2.3.96.SK.981120191524.357L-100000@sun.med.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Cleveland | 1998-11-20 20:03:54 | Monetary, Float Types |
| Previous Message | Jeroen Schaap | 1998-11-20 15:56:59 | Re: [GENERAL] Re: Large Objects |