Re: Date precision problem - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: Date precision problem
Date
Msg-id 3CBD3AEE.98D1BD6F@tpf.co.jp
Whole thread Raw
In response to Date precision problem  (noy <noyda@isoco.com>)
List pgsql-general
noy wrote:
>
> 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.

Is there no problem with 7.1.3 ?

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

pgsql-general by date:

Previous
From: Holger Marzen
Date:
Subject: Re: Poor performance with "large" table.
Next
From: noy
Date:
Subject: Re: Date precision problem