Skip site navigation (1) Skip section navigation (2)

Incorrect date/time returned by current_timestamp

From: "Colin Mangiagalli" <colin(at)camara(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Incorrect date/time returned by current_timestamp
Date: 2002-06-03 13:22:52
Message-ID: 000201c20b01$ca402730$7a01a8c0@camara.co.za (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Reinhard HnatDate: 2002-06-03 14:31:30
Subject: Changed function
Previous:From: Nicolas BazinDate: 2002-06-03 02:10:10
Subject: Re: [PORTS] ecpg not found

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group