https://bugs.documentfoundation.org/show_bug.cgi?id=117732
--- Comment #19 from Terrence Enger <[email protected]> ---
Julien Nabet wrote in comment 13:
> I don't know how to normalize the retrieved value here.
> Adding dateTime.IsUTC = true; or dateTime.IsUTC = false; change
> nothing on the results.
I am getting somewhat plausible results by running LO with envvar
TZ=UTC. For reference, with TZ=UTC, LibreOffice version 6.0.5.2
(currently in debian-buster) displays the table in the original hsqldb
file as:
id tst_dt tst_d tst_t
-- ------------------- ---------- --------
0 2010-01-01 15:10:00 2010-01-01 15:10:10
1 2010-02-01 23:30:00 2010-02-02 23:30:30
2 2010-03-01 05:00:00 2010-03-01 05:00:00
3 2010-04-02 03:30:00 2010-04-01 04:30:00
4 2010-06-01 02:15:00 2010-05-31 03:15:10
5 2010-06-30 04:00:00 2010-06-30 05:00:00
6 2010-07-01 02:22:00 2010-06-30 03:22:22
I take this as the best indication of what is "really" in the table.
--
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
