Note the first timezone change is taken, but the second one is ignored.

rbt=# select * from t;
          col
------------------------
 2003-06-03 14:30:25-04
(1 row)
 
rbt=# set time zone udt;
SET
rbt=# select * from t;
          col
------------------------
 2003-06-03 18:30:25+00
(1 row)
 
rbt=# set time zone est;
SET
rbt=# select * from t;
          col
------------------------
 2003-06-03 18:30:25+00
(1 row)

-- 
Rod Taylor <[EMAIL PROTECTED]>

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

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to