Re: Time is off in PG server - Mailing list pgsql-admin

Ericson Smith <eric@did-it.com> writes:
> I realized I made a mistake in that initial email (should have said 12am
> instead of pm). However, I tried:

>>> set local time zone 'EST5EDT';
> SET
>>> select now();

"set local" was probably not what you wanted to use here.  Per the man page:

    Note that SET LOCAL will appear to have no effect if it is executed outside
    a BEGIN block, since the transaction will end immediately.

            regards, tom lane