Use the AT TIME ZONE construct: http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#F UNCTIONS-DATETIME-ZONECONVERT -- Brandon Aiken CS/IT Systems Engineer -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Harry Hehl Sent: Monday, September 25, 2006 11:06 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] Timestamp with timezone query Hello, I have a table with TIMESTAMP WITH TIMEZONE column. I would like to query for a timestamp using a different timezone. For example if a column contains '2006-02-11 00:30:00-05' select * from table where column='2006-02-10 19:30:00+00' would return the column containing '2006-02-11 00:30:00-05'.
