Mike Harding wrote:
mvh=> set time zone 'UTC';
SET
mvh=> select now();
now
---
2007-02-13 03:37:35.660652+00
(1 row)
"+00" says your database thinks you are in Greenwich.
mvh=> select timestamp with time zone '2007-01-01' at time zone
'America/Los_Angeles';
timezon
Ron Johnson <[EMAIL PROTECTED]> writes:
> I think he's asking why:
> select timestamp with time zone '2007-01-01'
> at time zone 'America/Los_Angeles';
> returns a different value than
> select timestamp '2007-01-01'
> at time zone 'America/Los_Angeles';
Those are transform
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 01:42, Tom Lane wrote:
> Mike Harding <[EMAIL PROTECTED]> 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 aga
Mike Harding <[EMAIL PROTECTED]> 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.
