[Libreoffice-bugs] [Bug 133510] Time data (not time stamp) does not work properly.
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed Aug 26 15:41:32 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=133510
Robert Großkopf <robert at familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |robert at familiegrosskopf.de
--- Comment #9 from Robert Großkopf <robert at familiegrosskopf.de> ---
The stored procedure shouldn't be a problem. It is working in MySQL directly,
not in Base. Base has nothing to do with the calculation: Base will only show
the result it is reading from the database.
So I tried something with a minimalistic table:
3 fields, one with ID, next with title and third with duration.
All this created in Base, connected directly to MariaDB (haven't any MySQL
working here).
I filled in some data and started this query:
SELECT "ID", "title", "duration", ( SELECT SEC_TO_TIME(SUM( TIME_TO_SEC(
"duration" ) ) ) FROM "libretest"."TimeTest" "TimeTest" WHERE "ID" <= "a"."ID"
) "Sum_Duration_Time" FROM "libretest"."TimeTest" "a"
No problem to get the right sum of the duration for all "title". I have to
change the format for the column to [HH]:MM:SS only.
All tested with MariaDB and the direct driver from LO, LO-Version 6.4.6.2 on
OpenSUSE 15.1 64bit rpm Linux.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200826/2ea8b818/attachment.htm>
More information about the Libreoffice-bugs
mailing list