timezone problem

From: Daniel Kalchev <daniel(at)digsys(dot)bg>
To: pgsql-hackers(at)hub(dot)org
Subject: timezone problem
Date: 1999-03-27 13:04:43
Message-ID: 199903271304.PAA02438@dcave.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have just come across an weird datetime representation problem:

Under two BSD/OS machines, running 6.4.2. I get these two results:

customer=> select '28-03-1999'::datetime;
?column?
----------------------------
Sun 28 Mar 00:00:00 1999 EET
(1 row)

and

customer=> select '28-03-1999'::datetime;
?column?
-----------------------------
Sun 28 Mar 02:40:50 1999 EEST
(1 row)

The difference is... in the /etc/localtime file. The 'right' file is actually
quite older (the system has been upgraded from earlier versions several times
and the /etc/localtime is dated Oct 8 1996). The 'wrong' file is what recent
versions of BSD/OS install (at least after BSD/OS 3.0) for 'Europe/Sofia'.

Could some expect in datetime/timezone representation look at this - I am
attaching the two /etc/localtime files.

Regards,
Daniel

Attachment Content-Type Size
localtime text/plain 730 bytes
localtime text/plain 729 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1999-03-27 19:23:22 Re: [HACKERS] PostgreSQL LOGO
Previous Message pourreza 1999-03-27 07:30:07 Low Performance