However --> doesn't this make the extract(timezone_hour...) function basically useless? May as well call it "get_local_timezone_hour". How can one extract the timezone offset of a timestamp w/timezone (ie. get the intended behaviour of the extract call) ???
blackcherry=# SELECT extract(timezone_hour from TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05');
date_part
-----------
8
(1 row)
blackcherry=# SELECT extract(timezone_hour from TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-00');
date_part
-----------
8
(1 row)
-Dave
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org