regression=# set timezone to 'US/Arizona'; SET regression=# select now(); now ------------------------------- 2004-10-25 10:52:49.441559-07
Wow! When did that get fixed? How do I keep track of this stuff if you guys keep fixing it? ;-)
That's worked for ages. What doesn't work is this:
usatest=# select current_timestamp at time zone 'US/Arizona'; ERROR: time zone "us/arizona" not recognized
Chris
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
