Re: Date precision problem

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Date precision problem
Дата
Msg-id 3CBD3AEE.98D1BD6F@tpf.co.jp
обсуждение исходный текст
Ответ на Date precision problem  (noy <noyda@isoco.com>)
Список 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 по дате отправления:

Предыдущее
От: Holger Marzen
Дата:
Сообщение: Re: Poor performance with "large" table.
Следующее
От: noy
Дата:
Сообщение: Re: Date precision problem