From The Document Foundation Wiki
Jump to: navigation, search

The Migration Wizard does not manage to correctly migrate date fields, time fields, and date / time fields. This is because the HSQLDB works with local time zones. During the date-time migration, this suddenly turns into summer time values ​​that are 2 hours earlier, but only one hour in winter time. Dates are always advanced by one day, and so on. The following method helps to properly get the appropriate values ​​from the HSQLDB into the Firebird database, and then create time and date values ​​again: