[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