Re: Server Time Setting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lane Van Ingen" <lvaningen(at)esncc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Server Time Setting
Date: 2005-09-12 22:42:04
Message-ID: 6275.1126564924@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Lane Van Ingen" <lvaningen(at)esncc(dot)com> writes:
> I am baffled as to why some of the PostgreSQL functions (like now() ) are
> returning
> a time which is exactly an hour later than the server's actual system time.

I'd say you've got TimeZone set to something different than you think
you do.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John DeSoi 2005-09-13 04:41:05 Re: manage backup on a Window XP
Previous Message Tom Lane 2005-09-12 22:39:44 Re: ERROR: canceling query due to user request