Multi Time Zone Select

Karsten Hilbert · *nix forums addict Joined: 01 Mar 2005 Posts: 91

Vanole, Mike · *nix forums beginner Joined: 14 Mar 2005 Posts: 1

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

Google