Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Odd behaviour of timestamptz
- From: Matteo Beccati <php(at)beccati(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Odd behaviour of timestamptz
- Date: Thu, 22 Feb 2007 09:08:57 +0100
- Message-id: <45DD4F99(dot)2000608(at)beccati(dot)com>
Hi, Tom Lane wrote: > I'll bet you are running in Europe/Amsterdam time zone? The above is > correct behavior according to the zic data files (see below). Yes, for somewhat reason the server was installed using Europe/Amsterdam as timezone, that's why no other italian user could replicate the issue. Thanks everyone for the help and explanations! Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com
- References:
- Odd behaviour of timestamptz
- From: Matteo Beccati
- Re: Odd behaviour of timestamptz
- From: Tom Lane
- Odd behaviour of timestamptz
- Prev by Date: Re: postgresql vs mysql
- Next by Date: Checking for string data that makes sense Re: postgresql vs mysql
- Previous by thread: Re: Odd behaviour of timestamptz
- Next by thread: Slow running to_tsvector (tsearch2 in PG 8.2.3)
- Indexes: