Ericson Smith <eric(at)did-it(dot)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