On 7/23/2015 4:11 AM, Bruno Schw?gli (CTModule AG) wrote: > We use SQLite in an environment (ships) where a time zone change can happen > during normal operation. We then set the time zone of the system (windows) > accordingly. > Running SQLite instances do not respect this change. So Time('now') and > Time('now', 'localtime') still return the same values but in my opinion > Time('now', 'localtime') should respect the new time zone.
Have the host application listen to WM_SETTINGCHANGE message. When you detect time zone change, delete TZ environment variable (with _putenv or SetEnvironmentVariable ) and call _tzset -- Igor Tandetnik