Re: Pg subtracts one minute from time

Barry Stewart <bstewart@smyrnacable.net> writes:
> I'm using Trustix Secure Linux 1.2 (RedHat based) on a Pentium 200MMX and
> Postgresql 7.02.

Seems like a fairly vanilla-flavored platform...  I'm baffled, to tell
you the truth.  I sent a heads-up to our date/time maven, Thomas
Lockhart, who might have an idea what's going wrong here.

> How do I check the TZ/PGTZ variables?  On the command
> line, the date command says:
> Fri Jan 12 11:37:36 EST 2001

Try "echo $TZ" at the command line.  Given that date output, I'm
guessing that you'll see "EST5EDT".  Just for grins, you might try

    export PGTZ="EST5EDT"

before starting psql, and then see if the behavior is the same or not.
Probably won't help but it'd be worth making sure.

            regards, tom lane