Re: Setting date and time

I am running version 7.3.2 on Windows XP.

If I change the system date to a different date on the PC, and query the
database (Select current_date), the result I get is the date on the system
relative to when postmaster started as a service, not the new date on the
PC. Am I missing something really obvious?? : (

test=# select now();
now
----------------------------
2004-01-29 11:25:06.553-06
(1 row)

test=# \!
$ date
Thu Jan 29 11:25:09 CST 2004
$ date 01\25\2004
Sun Jan 25 20:04:00 CST 2004
$ date
Sun Jan 25 20:04:01 CST 2004
$ exit

test=# select now();
now
----------------------------
2004-01-29 11:25:34.032-06
(1 row)

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Weaver" <gweaver(at)shaw(dot)ca>
Cc: "Manuel Sugawara" <masm(at)fciencias(dot)unam(dot)mx>;
<pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, January 29, 2004 10:46 AM
Subject: Re: [NOVICE] Setting date and time

> George Weaver <gweaver(at)shaw(dot)ca> writes:
> > From what I can determine, postmaster gets the OS date and time when its
> > starts up, but then seems to maintain the data and time independently.
>
> This is certainly not so. Perhaps you should tell us exactly what you
> are doing to draw that conclusion ...
>
> regards, tom lane
>