[Libreoffice-bugs] [Bug 51523] EDITING: Database Format TIME [HH]:MM:SS not working
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Fri Jul 6 11:44:39 CEST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=51523
Lionel Elie Mamane <lionel at mamane.lu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
--- Comment #12 from Lionel Elie Mamane <lionel at mamane.lu> 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.
More information about the Libreoffice-bugs
mailing list