| 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: | Whole Thread | Raw Message | 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.
| 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 |