Re: Set default time zone for displaying dates in a session - Mailing list pgsql-novice

On 2011-01-28, Basil Bourque <basil.list@me.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