Re: Timezone strangeness - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Timezone strangeness
Date
Msg-id 1054755474.24785.3.camel@jester
Whole thread Raw
In response to Timezone strangeness  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
On Wed, 2003-06-04 at 14:55, Christopher Browne wrote:
> Rod Taylor wrote:
> > Note the first timezone change is taken, but the second one is ignored.
> > rbt=3D# set time zone est;
> > SET
> > rbt=3D# select * from t;
> >           col
> > ------------------------
> >  2003-06-03 18:30:25+00
> > (1 row)
>
> Are you certain "est" is a legitimate time zone?

I didn't think to look to see if it was valid as there wasn't an error
reported (so I had mistakenly assumed it was).

Anyway, right you are.. The full zone name is required to function as
expected.  To function in an unexpected fashion, anything is accepted :)

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: Carlos Guzman Alvarez
Date:
Subject: Re: Problem trying to implement version 3.0 of the PostgreSQL protocol
Next
From: Jan Wieck
Date:
Subject: Re: SAP and MySQL ...