https://bugs.freedesktop.org/show_bug.cgi?id=51523
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #12 from Lionel Elie Mamane <[email protected]> 2012-07-06 02:44:39 PDT --- (In reply to comment #9) > (In reply to comment #2) >> 5) Are your fields of type "DATE", "DATETIME", "TIMESTAMP", something else? > Fields are of type TIME 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. 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 think your best bet right now is to use a float/real/double/decimal type for the column, and format [HH]:MM:SS for output. The true solution would be the INTERVAL column type, but it is not supported by current version of LibO (and neither by the old embedded HSQLDB it uses) :-( >> and if not an embedded HSQL one (e.g. MySQL or >> PostgreSQL), then also attach the SQL script to run against the server to >> create the example database. > Sorry but poor me as user don't know how :( Your example is embedded HSQLDB, so no need for a SQL script (it is included in the .odb). -- 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
