Incorrect date/time returned by CURRENT_TIMESTAMP

From: "Colin Mangiagalli" <colin(at)camara(dot)co(dot)za>
To: <pgsql-cygwin(at)postgresql(dot)org>
Cc: <richard(at)camara(dot)co(dot)za>, <colin(at)camara(dot)co(dot)za>, "Carlos Camara" <carlos(at)camara(dot)co(dot)za>
Subject: Incorrect date/time returned by CURRENT_TIMESTAMP
Date: 2002-06-05 08:29:20
Message-ID: 001801c20c6b$19bb3b50$7a01a8c0@camara.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Richard Wooding 2002-06-05 08:33:35 Re: Incorrect date/time returned by CURRENT_TIMESTAMP
Previous Message Vernon Wu 2002-06-05 03:40:37 What is wrong ?