[Libreoffice-bugs] [Bug 133510] New: Time data (not time stamp) does not work properly.

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: cscj01 at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200530/6bb0a876/attachment.htm>