https://bugs.documentfoundation.org/show_bug.cgi?id=133510
Bug ID: 133510
Summary: Time data (not time stamp) does not work properly.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 161418
--> https://bugs.documentfoundation.org/attachment.cgi?id=161418&action=edit
Base form for Tracks data nd MySQL queries of the same data.
When you have a series of time data of the form HH:MM:SS, Base does not display
the data correctly.
Specific case:
I have a set of records from a music data base that are in a table named
tracks. The tracks rows contain time fields labeled "start_time and "length.
These two fields are defined as data type time and contain times in the form
HH:MM:SS. The Base form in which these values are entered is shown below.
Clearly, the values shown in the length field are incorrect. The format is
13:47:46. The actually data in a MySQL database that holds the data. A query
of that particular set of tracks shows the data correctly. I also have queries
of the MySQL data of the same data that shows the data correctly.
Additionally, if I enter a new set of tracks for another record/CD, the data
shows as being enter correctly, but the MySQL query shows the data as having
been shifted to the left. So the ones that are correct on an SQL query were
entered from a 5.x version of Base. The one shown in the submitted images with
the shifted data on the SQL query was entered under a 6.x version of Base.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
