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.
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 |