https://bugs.freedesktop.org/show_bug.cgi?id=51523
--- Comment #13 from Cocky Cwiek <[email protected]> 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. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
