Re: Timestamp/Timezone - does this make sense? - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/14/07 01:42, Tom Lane wrote:
> Mike Harding <mharding@edentreetech.com> writes:
>> Where does that extra 8 hours come from?
>
> Ellay is 8 hours west of UTC (at least on 1-Jan, at least till our
> congresscritters see fit to monkey with the DST laws again).  What
> problem have you got with these answers?  They look right to me.

I think he's asking why:
    select timestamp with time zone '2007-01-01'
        at time zone 'America/Los_Angeles';
    ---------------------
    2006-12-31 16:00:00

returns a different value than
    select timestamp '2007-01-01'
        at time zone 'America/Los_Angeles';
    ------------------------
    2007-01-01 08:00:00+00
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF0sNSS9HxQb37XmcRAuFXAJ0Z82uaW7FKKAuCnYbrm/bh8MAyCgCfWUW5
2blMHVkmjhYEjsGzk0o+ybM=
=GbW7
-----END PGP SIGNATURE-----