Re: Per-query local timezone - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Per-query local timezone
Date
Msg-id 20110614100506.GM2617@hermes.hilbert.loc
Whole thread Raw
In response to Per-query local timezone  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
Responses Re: Per-query local timezone  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
List pgsql-general
On Tue, Jun 14, 2011 at 09:40:20AM +0000, Mark Morgan Lloyd wrote:

> Is it possible to incorporate SET TIMEZONE into a query, so that
> to_char(...'TZ') etc. is appropriately localised?

You seem to want "AT TIME ZONE".

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Per-query local timezone
Next
From: John R Pierce
Date:
Subject: Re: Per-query local timezone