Re: Set default time zone for displaying dates in a session

On 2011-01-28, Basil Bourque <basil(dot)list(at)me(dot)com> wrote:

> Is there a way to set a different time zone as the default for a session?

> By default, Postgres displays my data stored in "TIMESTAMP WITH TIME
> ZONE" columns' data as a local time for the time zone of the computer
> hosting the Postgres cluster.
>
> If my Postgres server is in Seattle, but my user is in New York, I
> want the times shown in New York time zone.

-- once per session.
SET TIMEZONE TO 'America/New_York';

-- or once only
ALTER USER username SET TIMEZONE TO 'America/New_York';

or you can do the whole database with ALTER DATABASE.

--
⚂⚃ 100% natural