| 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: | Whole Thread | Raw Message | 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 |
| 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 |