Bug 100623 - Dates changed automatically in databases
Summary: Dates changed automatically in databases
Status: RESOLVED DUPLICATE of bug 63566
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2016-06-26 17:58 UTC by Gerhard Schaber
Modified: 2016-06-26 18:06 UTC (History)
0 users

See Also:
Crash report or crash signature:

Sample database (49.20 KB, application/vnd.sun.xml.base)
2016-06-26 17:58 UTC, Gerhard Schaber

Note You need to log in before you can comment on or make changes to this bug.
Description Gerhard Schaber 2016-06-26 17:58:10 UTC
Created attachment 125928 [details]
Sample database

Date values in a database are changed automatically when the time zone of the system is changed to an hour earlier, and does not change back when you change the time zone back. I consider this a data loss, because with a complex database there is no way to know in which table dates were changed and how often.

1. Load the attached database. Check the dates in the table DateTable
2. Close the database file
3. Change the time zone by -1 hour
4. Load the attached database. See that all dates have changed
5. Close the database file
6. Change the time zone back to the original one
7. Load the attached database. See that all dates did not change back to the original values
Comment 1 Gerhard Schaber 2016-06-26 18:06:48 UTC

*** This bug has been marked as a duplicate of bug 63566 ***