https://bugs.documentfoundation.org/show_bug.cgi?id=127498
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Assignee|[email protected] |[email protected] |desktop.org | --- Comment #4 from Eike Rathke <[email protected]> --- When using a time format with fractional seconds HH:MM:SS.000000000 it can easily be seen that due to floating point inaccuracies the values are 08:00:00.000000210 08:15:00.000000000 08:29:59.999999790 08:45:00.000000210 09:00:00.000000000 09:14:59.999999790 ... Let's do an internal rounding to 300 nanoseconds for TIMEVALUE() like it's now done in other date+time places as well. -- You are receiving this mail because: You are the assignee for the bug.
