[Libreoffice-bugs] [Bug 63566] HSQLDB: Date will be changed when timezone of OS is changed

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #16 from Gerhard Schaber <gerhard.schaber at gmx.at> ---
I cannot use VARCHAR, because then there is no localization of the date format.
I cannot use DATE, because that corrupts the data once the time zone is changed
towards the west. I cannot use TIMESTAMP, because when using input dialogs for
queries, it asks for a time as well as the date, which is impractical. I cannot
use HSQLDB 2.3.2 with a split database, because this is not supported by the LO
table editing tools (everything greyed out). And I cannot use Firebird, because
there are still a couple of serious open issues that still makes it unusable
for me (although I have prepared everything for a transition, the last 10% are
not working because of the open issues).

So that means risking data corruption as soon as I change the time zone when I
am travelling.

It would be great to have some practical workaround for this (other than having
to write a macro that goes through all date fields of all tables and fix the
dates). Any suggestions are welcome.

-- 
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/20171213/b3cb991e/attachment-0001.html>