Per-query local timezone

From: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: Per-query local timezone
Date: 2011-06-14 09:40:20
Message-ID: it7aa6$20i$1@pye-srv-01.telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2011-06-14 09:42:26 Re: how to install plpython?
Previous Message AI Rumman 2011-06-14 09:17:32 Re: how to install plpython?