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@sss.pgh.pa.us>
To: "George Weaver" <gweaver@shaw.ca>
Cc: "Manuel Sugawara" <masm@fciencias.unam.mx>;
<pgsql-novice@postgresql.org>
Sent: Thursday, January 29, 2004 10:46 AM
Subject: Re: [NOVICE] Setting date and time
> George Weaver <gweaver@shaw.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
>