https://bugs.documentfoundation.org/show_bug.cgi?id=117732
--- Comment #5 from Julien Nabet <serval2...@yahoo.fr> ---
Created attachment 142257
--> https://bugs.documentfoundation.org/attachment.cgi?id=142257&action=edit
test each hour, from 00:00 (12AM) to 24:00 (12PM) included
I created a brand new hsqldb file with 6.0.4.1 LO Debian package.
I created a first table with each hour, from 00:00 to 24:00 with AM/PM format.
Then, added trace with this patch:
diff --git a/dbaccess/source/filter/hsqldb/rowinputbinary.cxx
b/dbaccess/source/filter/hsqldb/rowinputbinary.cxx
index 62c37525367d..225f5b235bf5 100644
--- a/dbaccess/source/filter/hsqldb/rowinputbinary.cxx
+++ b/dbaccess/source/filter/hsqldb/rowinputbinary.cxx
@@ -16,7 +16,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
-
+#include <iostream>
#include "rowinputbinary.hxx"
#include <com/sun/star/sdbc/DataType.hpp>
#include <com/sun/star/io/WrongFormatException.hpp>
@@ -333,6 +333,7 @@ std::vector<Any> HsqlRowInputStream::readOneRow(const
ColumnTypeVector& nColType
{
sal_Int64 value = 0;
m_pStream->ReadInt64(value);
+std::cerr << "value = " << value << "\n";
css::util::Time time((value % 1000) * 1000000, value / 1000,
0, 0, true);
aData.push_back(makeAny(time));
}
Here are the weird results:
-3600000
0
3600000
7200000
10800000
14400000
18000000
21600000
25200000
28800000
32400000
36000000
39600000
43200000
46800000
50400000
54000000
57600000
61200000
64800000
68400000
72000000
75600000
79200000
-3600000
1) it begins to -3600000
2) At the end, the difference isn't 3600000 between each line
I think we must understand these values to get right hours
I tried some values on table 2 since I created it by letting the default format
on 24H.
(still on France with French localization and UTC+2)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
