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@hotmail.com
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
