Thread: Date/time problems on Linux

Date/time problems on Linux

From
Oleg Broytmann
Date:
Hello!

=> SELECT datetime(current_date, '11:00');
datetime                    
----------------------------
Mon 23 Nov 11:00:00 1998 MSK
(1 row)
  I got correct result (11:00:00 MSK) on Sparc Solaris 2.5.1 and RedHat 4.2.
I got incorrect result (17:00:00 MSK) on RedHat 5.1 and Debian 2.0. (All
postgres 6.4)
  It looks like problem with libc5-to-glibc2 transition, but I don't see
how to test who cause the problem - Postgres or Linux. How can I test?

Oleg.
----    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/          Programmers don't die, they
justGOSUB without RETURN.