Re: automatic time zone conversion

On Wednesday, June 12, 2002, at 11:57 PM, Tom Lane wrote:
> If you want automatic handling of summer times the correct approach is
> to leave off the timezone spec on entry, whereupon PG will intuit the
> correct GMT offset for your timezone rules (as set by the TimeZone
> setting). For instance:
>
> test72=# set timezone to EST5EDT;
> SET VARIABLE
> test72=# select '02/03/2002 12:00:00'::timestamp with time zone;
> timestamptz
> ------------------------
> 2002-02-03 12:00:00-05
> (1 row)
>
> test72=# select '06/03/2002 12:00:00'::timestamp with time zone;
> timestamptz
> ------------------------
> 2002-06-03 12:00:00-04
> (1 row)

Aha - I think that's what I want. Thanks.

I'm getting incredibly confused about the zones, though,
probably because I'm in Australia. On my system, I see this:

[sa0110e0:~] kenw> env|grep -i z
TZ=EET-10EETDT,M10.5.0,M3.5.0

But what's EET? Postgres seems to define that as something in
Eastern Europe. Is there a conflict here? And where can I find
out what all the Mx.x.x stuff means? Is it system-dependent?
(This is AIX.)

Thanks.

-Ken