| 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 |
| Subject: | Re: Setting date and time |
| Date: | 2004-01-29 18:00:07 |
| Message-ID: | 24919.1075399207@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
George Weaver <gweaver(at)shaw(dot)ca> writes:
> 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?? : (
Hm, you're running PG under Cygwin then? This must be a Cygwin issue.
Postgres itself gets the time from the operating system at the start of
each transaction, and it's going to believe whatever the Cygwin
implementation of gettimeofday() tells it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael J. Conroy | 2004-01-29 20:00:34 | "[" is a nuisance... |
| Previous Message | George Weaver | 2004-01-29 17:28:23 | Re: Setting date and time |