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

Karsten Hilbert wrote:
> 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".

Thanks for that. How can I do /this/

select to_char(now() at time zone 'GMT0BST', 'TZ');

It appears to return '', while if I used a separate SET TIMEZONE I'd
expect 'BST'.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]