Postgres Pro
Downloads
Home   >   mailing lists

Incorrect date/time returned by current_timestamp - Mailing list pgsql-novice

From Colin Mangiagalli
Subject Incorrect date/time returned by current_timestamp
Date
Msg-id 000201c20b01$ca402730$7a01a8c0@camara.co.za
Whole thread Raw
Responses Re: Incorrect date/time returned by current_timestamp  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-novice
Tree view

Hi there

I am using postgresql 7.2.1 with cygwin under W2K. I have noticed that when I start postmaster, current_timestamp
returns the correct time, but as time goes by, the value returned by current_timestamp gets further and further
from the current system time.

Can someone please tell me why this is and what I can do to fix it.

Thanks
Colin

pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: Question on joining tables
Next
From: "Nicolas Bazin"
Date:
Subject: Re: [PORTS] ecpg not found