Re: Setting date and time
От | George Weaver |
---|---|
Тема | Re: Setting date and time |
Дата | |
Msg-id | 00ac01c3e68d$4c2b9e10$6400a8c0@Dell4500 обсуждение исходный текст |
Ответ на | Setting date and time (George Weaver <gweaver@shaw.ca>) |
Ответы |
Re: Setting date and time
|
Список | pgsql-novice |
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 >
В списке pgsql-novice по дате отправления: