[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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|medium                      |high
           Severity|normal                      |major

--- Comment #13 from Julien Nabet <serval2412 at yahoo.fr> ---
Thank you Noel for the code pointer. I don't know if the patch for time part is
ok but date and datetime are even more complicated to deal.
datetime part of table of Drew's file show a difference of 1 hour or 2 hours
depending on the row!
I don't know how to normalize the retrieved value here.
Adding dateTime.IsUTC = true; or dateTime.IsUTC = false; change nothing on the
results.
The only thing I found is no need to use Boost (ptime/millisec) since we can
use DateTime::CreateFromUnixTime to get the same result.

I think we should include some warning message in dialog box which proposes the
conversion of FB. Indeed, the FB migration is not safe at all for the moment.

BTW, I think we can add DATE in the bugtitle in addition to DATETIME and TIME
since DATE may also be wrong.

Let's increase the importance because it's not a corner case and it corrupts 
data silently.

-- 
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/20180526/aaeafe62/attachment.html>