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@wolff.to] Sent: May 13, 2004 2:07 PM To: Anony Mous Cc: pgsql-general@postgresql.org Subject: Re: setting local time without restarting server On Thu, May 13, 2004 at 12:56:48 -0600, Anony Mous <A.Mous@shaw.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'; ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
