Per-query local timezone - Mailing list pgsql-general

From Mark Morgan Lloyd
Subject Per-query local timezone
Date
Msg-id it7aa6$20i$1@pye-srv-01.telemetry.co.uk
Whole thread Raw
Responses Re: Per-query local timezone
Re: Per-query local timezone
List pgsql-general
Is it possible to incorporate SET TIMEZONE into a query, so that
to_char(...'TZ') etc. is appropriately localised?

The development environment I'm working with uses short-lifetime
sessions, and it's proving difficult to get a set command and a query
associated with the same handle.

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

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

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: determine client os
Next
From: Karsten Hilbert
Date:
Subject: Re: Per-query local timezone