Re: setting local time without restarting server

Thanks, but I do want to set the system time.

It's actually for testing purposes. Our software looks to the db server to
obtain the local date and time, however, to test various cases we need to
fiddle with this value. I'd like to do it without having to first change
the system time, and then re-start the postmaster. Sorry, I should have
clarified this in my first e-mail.

-Peter

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: May 13, 2004 2:07 PM
To: Anony Mous
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] setting local time without restarting server

On Thu, May 13, 2004 at 12:56:48 -0600,
Anony Mous <A(dot)Mous(at)shaw(dot)ca> wrote:
> Hi,
>
> Is there a function that would allow me to set the local time while the
> server is running? I can't seem to find anything on this...

You probably want to set the timezone, not the local time.
You can do that with something like:
SET TIMEZONE='EST5EDT';