From: Tom Kreiner <tom_kreiner@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Getting Hour From a Time in Different Time Zone
Date: Wed, 02 Jan 2002 16:45:57 -0500
Message-ID: <F41s3bi6DigZBq9s8OV00014ba2@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tom_kreiner@hotmail.com
Subject: Re: Getting Hour From a Time in Different Time Zone
In-Reply-To: <F41s3bi6DigZBq9s8OV00014ba2@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox