[Libreoffice-bugs] [Bug 51523] EDITING: Database Format TIME [HH]:MM:SS not working

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=51523

--- Comment #13 from Cocky Cwiek <cwiek at home.nl> 2012-07-06 05:40:52 PDT ---
(In reply to comment #12)



> That's your problem. SQL type "TIME" stores values between "00:00:00" and
> "23:59:59" (or possibly "23:59:60" if the implementation is that good that it
> handles leap seconds; I doubt any implementation is that good). So it is not
> the *format* that does not work, but you are using the wrong column type. What
> you are trying to do is akin to trying to store "600" in a TINYINT column: it
> will wrap around and *store* 88 because you are beyond the range handled by the
> column.
If that is so, then why is there a menu in editing a tablefield that gives the
possibillity to choose the format TIME (876613:37:46). If the possibillity is
given and in the helpfile also mentioned, a user should be able to use it
without complications. If a option is INVALID than take it out of the program.


> Try with TIMESTAMP (Date/Time) type, it is hackish, but it seems to sorta-work
> when the data is entered under date format (as e.g. "50:00:00"), and only
> formatted as [HH]:MM:SS later for printing / output.
I will try this. Thanks for the help so far!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.