Thread: Multi Time Zone Select

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

> 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?
If you look at the archives from, what, one day ago you'll
find a discussion and one possible solution.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346