Translations:Documentation/HowTo/MigrateFromHSQLDB/7/en
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: