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 16:40:02
Message-ID: 20010112114002.A6652@genesis.kingdom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm using Trustix Secure Linux 1.2 (RedHat based) on a Pentium 200MMX and
Postgresql 7.02. How do I check the TZ/PGTZ variables? On the command
line, the date command says:

Fri Jan 12 11:37:36 EST 2001

Barry

On 2001.01.12 11:00:35 -0500 Tom Lane wrote:
> Barry Stewart <bstewart(at)smyrnacable(dot)net> writes:
> > Postgresql subtracts one minute from any times I enter into a database:
>
> Bizarre. What platform are you running on? What Postgres version?
> What timezone setting (TZ or PGTZ variable) do you use?
>
> regards, tom lane
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-12 16:50:20 Re: Pg subtracts one minute from time
Previous Message Rosa Maria Carro Salas 2001-01-12 16:12:59 Re: RecordSets, getString and charSets