Re: Problem migrating dump to latest CVS snapshot.

Gunnar R|nning <gunnar(at)candleweb(dot)no> writes:
> 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)

Ah-hah. And we print that with a "%.2f" sort of format, so it rounds
off to 60.00. Even in IEEE arithmetic ;-)

I've suggested before that timestamp output should round the timestamp
value to two fractional digits *before* breaking it down into year/
month/etc. Seems like this is a perfect example of the necessity
for that. Thomas, what say you?

regards, tom lane