Re: Date precision problem

...
> This is all the sequence to obtain the error. ACCESS includes in the where
> clause "last_update" = '2002-04-17 16:40:44.548' and postgres has '2002-04-17
> 16:40:44.548177+02'  These two dates are different and the row is not updated
> because there is not matching row.

So how did Access decide that it had a three digit fractional seconds
field? afaik neither PostgreSQL nor its ODBC driver are truncating the
time.

If you need to constrain times to have a limited precision, you might
try defining things as (in this case) "timestamp(3)" rather than just
"timestamp". And perhaps others have some experience in tweaking Access
to give you, uh, access to the data you have.

                     - Thomas