On Fri, Dec 25, 2009 at 1:58 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> Isn't it the client timezone and not the system timezone that actually
> sets the tz the tstz is set to on retrieval?
It's the GUC:
stark=> set timezone = 'America/Los_Angeles';
SET
stark=> select now();
now
-------------------------------
2009-12-25 06:44:33.238187-08
(1 row)
I'm not sure if and how we initialize the GUC on a new connection
though. It might vary depending on the driver you use too.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
