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]
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general