Re: automatic time zone conversion

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ken Williams <ken(at)mathforum(dot)org>, Thomas Lockhart <lockhart(at)fourpalms(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: automatic time zone conversion
Date: 2002-06-13 07:04:50
Message-ID: 20020613170450.A14149@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 12, 2002 at 10:27:20PM -0400, Tom Lane wrote:
> Ken Williams <ken(at)mathforum(dot)org> writes:
> > 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?
>
> Looks like it. Perhaps EET needs to be another name that has
> two different interpretations depending on AUSTRALIAN_TIMEZONES.
> What fun...

I would hve no problem with stripping out the whole australian timezone
stuff, if only the following would work:

# date --date='6 april 2002 12:00 AEST'
date: invalid date april 2002 12:00 AEST'
# date --date='6 april 2002 12:00 ACST'
date: invalid date april 2002 12:00 ACST'
# date --date='6 april 2002 12:00 ADST'
date: invalid date april 2002 12:00 ADST'

# date --date='6 april 2002 12:00 EST'
Sun Apr 7 03:00:00 EST 2002

What timezone should we be using?

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Morcombe 2002-06-13 07:09:31 Help required with installing postgreSQL on SCO Openserver
Previous Message Jim Morcombe 2002-06-13 06:24:57 Help required with installing postgreSQL on SCO Openserver