> > I just checked the changelogs and Debian has integrated lots of upstream
> > patches into glibc-2.0.6. So maybe this wasn't fixed before 2.0.6. I'm
> > currently running 2.0.7pre1 and that one is fine.
>
> Andrew, could you add this to the Linux FAQ? The problem statement is:
>
> Q:
> Why do I get funny rounding results in some date/time arithmetic, such as
> select '4 hours'::timespan;
> returning '3 hours 59 minutes 60 seconds'?
>
Have done....
Andrew
p.s. BRUCE! Could I remind you to make sure the latest FAQs get into the
distribution :-)
----------------------------------------------------------------------------
Dr. Andrew C.R. Martin University College London
EMAIL: (Work) martin@biochem.ucl.ac.uk (Home) andrew@stagleys.demon.co.uk
URL: http://www.biochem.ucl.ac.uk/~martin
Tel: (Work) +44(0)171 419 3890 (Home) +44(0)1372 275775