From: | "Vanole, Mike" <Mike(dot)Vanole(at)cingular(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Multi Time Zone Select |
Date: | 2005-03-14 23:07:09 |
Message-ID: | EC80B396EC02F24C802F8C33FA8437E918BEDE@TX-MSG10-ALN.wireless.attws.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I load date information from different time zones into a single table.
My columns are defined 'timestamp(0) with time zone' and I'm loading
'2005-03-01 22:00:00-05:00' and '2005-03-01 23:00:00-06:00' for
example. I query this table and expect rows from all time zones and I
want to see the time zones in the result. But when I select he data all
rows return converted to my local time zone for each timezone. Since
this is a single query (select * ...) I don't know where to apply AT
TIME ZONE 'zone'. Is there a way to specify that I want the time data
presented according to the way the data is stored - by time zone?
Many thanks in advance.
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | David Gagnon | 2005-03-14 23:20:27 | Re: Problem with special character � on |
Previous Message | Chris Browne | 2005-03-14 23:04:01 | Re: prelimiary performance comparison pgsql vs mysql |