[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #19 from Terrence Enger <lo_bugs at iseries-guru.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180705/b9ee8db2/attachment.html>