Skip site navigation (1) Skip section navigation (2)

Re: Pg subtracts one minute from time

From: Barry Stewart <bstewart(at)smyrnacable(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: bstewart(at)smyrnacable(dot)net, pgsql-novice(at)postgresql(dot)org
Subject: Re: Pg subtracts one minute from time
Date: 2001-01-12 17:45:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
echo $TZ and echo $PGTZ both came up empty.  So I exported both as
"EST5EDT" (as root) and restarted postgresql, but still no luck.

Thanks for your prompt attention.  I'm going to give more info to Thomas,
but if you have any more suggestions, let me know.

Thanks for your prompt attention,


On 2001.01.12 11:50:20 -0500 Tom Lane wrote:
> 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

pgsql-novice by date

Next:From: Ken CoreyDate: 2001-01-12 18:08:49
Subject: Syntax highlighting for plpgsql (in VIM, even)?
Previous:From: Tom LaneDate: 2001-01-12 16:50:20
Subject: Re: Pg subtracts one minute from time

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group