Re: Problem migrating dump to latest CVS snapshot.
Gunnar R|nning <gunnar@candleweb.no>
From: Gunnar R|nning <gunnar@candleweb.no>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
Date: 2001-03-23T02:07:16Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
>
> If you still have the value stored in the original database, please try
> select date_part('seconds', ...)
> to see what that reports as the true seconds part of the value.
>
Seems you hit the nail with your theory :
sf-ng=# select date_part('seconds', a_accesstime) from access_log where
a_accesstime > '2000-10-24 15:14:59' limit 1;
date_part
-----------
59.997
(1 row)
sf-ng=#
regards,
Gunnar