pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (2+ messages)  latest in thread

Message-ID: <F41s3bi6DigZBq9s8OV00014ba2@hotmail.com>
Permalink:  ../F41s3bi6DigZBq9s8OV00014ba2@hotmail.com/
Also on:    postgresql.org/message-id/F41s3bi6DigZBq9s8OV00014ba2@hotmail.com

 · 

reply

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