Re: automatic time zone conversion - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: automatic time zone conversion
Date
Msg-id 20020613170450.A14149@svana.org
Whole thread Raw
In response to Re: automatic time zone conversion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Jun 12, 2002 at 10:27:20PM -0400, Tom Lane wrote:
> Ken Williams <ken@mathforum.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@svana.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.

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Troubleshooting SPI_execp() failed in
Next
From: "Jim Morcombe"
Date:
Subject: Help required with installing postgreSQL on SCO Openserver