| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | hubert depesz lubaczewski <depesz(at)gmail(dot)com>, Matteo Beccati <php(at)beccati(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Odd behaviour of timestamptz |
| Date: | 2007-02-22 06:22:11 |
| Message-ID: | 6743.1172125331@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Marlowe <smarlowe(at)g2switchworks(dot)com> writes:
> On Wed, 2007-02-21 at 13:21, hubert depesz lubaczewski wrote:
>> On 2/21/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> I'll bet you are running in Europe/Amsterdam time zone? The
>>> above is
>>
>> what about me? i'm in poland, and runing in europe/warsaw time zone. i
>> assume we also had some issues lie this - where can i read about it?
> Take a look here:
> http://en.wikipedia.org/wiki/Time_zone
Also, the zic data that Postgres uses can be seen in our CVS:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/data/
The comments in those files are, um, extensive.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-02-22 06:51:21 | Re: Row-Level Access Control via FK to pg_catalog.pg_authid |
| Previous Message | Joshua D. Drake | 2007-02-22 06:17:31 | Re: postgresql vs mysql |