Incorrect date/time returned by CURRENT_TIMESTAMP - Mailing list pgsql-cygwin

From Colin Mangiagalli
Subject Incorrect date/time returned by CURRENT_TIMESTAMP
Date
Msg-id 001801c20c6b$19bb3b50$7a01a8c0@camara.co.za
Whole thread Raw
Responses Re: Incorrect date/time returned by CURRENT_TIMESTAMP  (Joel Burton <joel@joelburton.com>)
List pgsql-cygwin
Hi,

My implementation of Postgresql is as followes:

Postgresql Version: PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC
2.95.3-5
Cygwin dll: 1.3.10
Operating system: Windows 2000 Service Pack 2
Processor: Intel Pentium III 1 Ghz
Bios: Award Moduler Bios v6.00pg

When I start postmaster and run 'select CURRENT_TIMESTAMP;', the date
and time
are correct. After a hour, I run 'select CURRENT_TIMESTAMP;' and see
that the
time is not the same as the system clock, in fact it is quite far
behind.

Can someone please tell me what could possibly be causing this.

Thanks
Colin


pgsql-cygwin by date:

Previous
From: "Ben"
Date:
Subject: Postgres in Windows
Next
From: "Richard Wooding"
Date:
Subject: Re: Incorrect date/time returned by CURRENT_TIMESTAMP