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
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 |