[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
Sun Jun 28 04:47:01 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=133510

--- Comment #3 from Cecil Carpenter <cscj01 at gmail.com> ---
How to make Base fail with Time field in a MySQL DB.

(1) Create a table column of type Time in an MySQL table with format HH:MM:SS.
(2) Create a stored procedure that totals the time for all the rows that have
time date entered.
(3) Create a Base form for this MySQL table.
(4) In the Base Form, choose Column for the Time column.
(5) The only option that includes the 3 elements of time (HH:MM:SS) is
13:45:00.
(6) Choose 13:45:00.
(7)  Enter data in a number of rows where the the hours a zero, the minutes are
less than 60, and the seconds are also less than 60.
(8) Execute the stored procedure that calculates the total time.
(9) The results calculated are incorrect because the time is being shifted as
well as being calculated incorrectly.

-- 
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/20200628/5ccde50b/attachment.htm>


More information about the Libreoffice-bugs mailing list