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 <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
Description: This is a digitally signed message part