Re: date_trunc on date is immutable?

On Fri, Dec 25, 2009 at 1:58 AM, Scott Marlowe  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