Date precision problem

From: noy <noyda(at)isoco(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Date precision problem
Date: 2002-04-11 15:40:38
Message-ID: 3CB5AE76.C40C3425@isoco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I having some problem with the date fields migration from 7.1.3 version to 7.2
version...

In my current version PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC
2.96 I get this result

select now();
now
------------------------
2002-04-11 12:58:33+02
(1 row)

In the new version PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96

SELECT NOW();
now
-------------------------------
2002-04-11 13:02:27.943119+02
(1 row)

The date is different in the last part:

2002-04-11 13:02:27.943119+02
^^^^^^^^^
Then when I am trying to update this field from ACCESS I have an error and the
entry can't be updated because the dates are not equals.

Someone can help me?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rick Szeto 2002-04-11 16:01:29 "NOT IN" predicate hangs result
Previous Message Stephan Szabo 2002-04-11 15:40:16 Re: Strange row locking - question