| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Christopher Browne <cbbrowne(at)cbbrowne(dot)com> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Timezone strangeness |
| Date: | 2003-06-04 19:37:55 |
| Message-ID: | 1054755474.24785.3.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Guzman Alvarez | 2003-06-04 20:02:10 | [Fwd: Re: Problem trying to implement version 3.0 of the PostgreSQL protocol in C#] |
| Previous Message | Jan Wieck | 2003-06-04 19:25:35 | Re: SAP and MySQL ... |