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
Sat, 27 Mar 1999 15:04:43 +0200
Daniel Kalchev <daniel@digsys.bg>
timezone problem