https://bugs.documentfoundation.org/show_bug.cgi?id=63566
--- Comment #16 from Gerhard Schaber <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
