Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Odd behaviour of timestamptz
- 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: Thu, 22 Feb 2007 01:22:11 -0500
- Message-id: <6743(dot)1172125331(at)sss(dot)pgh(dot)pa(dot)us>
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
- References:
- Odd behaviour of timestamptz
- From: Matteo Beccati
- Re: Odd behaviour of timestamptz
- From: Tom Lane
- Re: Odd behaviour of timestamptz
- From: hubert depesz lubaczewski
- Re: Odd behaviour of timestamptz
- From: Scott Marlowe
- Odd behaviour of timestamptz
- Prev by Date: Re: postgresql vs mysql
- Next by Date: Re: Row-Level Access Control via FK to pg_catalog.pg_authid
- Previous by thread: Re: Odd behaviour of timestamptz
- Next by thread: Re: Odd behaviour of timestamptz
- Indexes: