Re: Pg subtracts one minute from time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bstewart(at)smyrnacable(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Pg subtracts one minute from time
Date: 2001-01-12 16:50:20
Message-ID: 16332.979318220@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Barry Stewart <bstewart(at)smyrnacable(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Barry Stewart 2001-01-12 17:45:30 Re: Pg subtracts one minute from time
Previous Message Barry Stewart 2001-01-12 16:40:02 Re: Pg subtracts one minute from time