Getting Hour From a Time in Different Time Zone

I'm working on a web interface that will be taking into account that the
users will be in different time zones. In one of my queries, I need to
extract the hour of a time that has been converted to the appropriate time
zone. Everytime I do this, the hour function gives me he hour in the
server's time zone, not in the time zone I'm trying to convert to.

For example, the server's time zone is -08. I'm in time zone -05. Assume
that current_timestamp (for the server) is 9:00 AM. I know that:

SELECT current_timestamp AT TIME ZONE INTERVAL '-05 hours';

gives me 12:00 PM, which is the correct time for my time zone. However, if I
do:

SELECT hour(timestamp(current_timestamp AT TIME ZONE INTERVAL '-05 hours'));

I get 9. The server is returning the hour for it's designated time zone. In
essence, it's undoing the time zone change.

I need the hour for the converted time zone time. Has anyone else had this
problem and found a solution for it? Thanks.

Tom Kreiner
tom_kreiner(at)hotmail(dot)com

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx