Ken -
Note that we're talking _system_ time, so you won't find the answer in
the RDBMS docs - it's in the underlying OS docs. You don't mention what
OS you're running, and what it's idea of the current time is, so we
can't help you very well. If it's some flavor of unix, try looking at
'man date'. Personally, I use ntp to keep my linux system sync'ed with
a timeserver on campus.
Ross
On Fri, Mar 15, 2002 at 05:29:32PM +0000, Ken Corey wrote:
> Hi All,
>
> I've just realized that our (production, naturally) database's idea of the
> current date/time is 24 hours and 14 minutes fast. What a weird thing.
>
> So, is there a way to set the date/time? I've hit the mail archives,
> searchable docs, gone through Bruce Momjian's book, hit google, even
> sacrificed a few chickens just on the off chance, and found nothing.
>
> Lots of queries about dates, times, or how to find the current system
> time...but not how to SET the current system date.
>
> Argh! Help!
>
> (P.S. I'd _love_ an RTFM answer as long as you tell me where the FM is...;^)
>
> ---
> Ken Corey CTO Atomic Interactive, Ltd. http://www.atomic-interactive.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)