Managing Time Zones and Local Time

From QPR ProcessAnalyzer Wiki
Revision as of 14:07, 16 November 2021 by Ollvihe (talk | contribs) (Created page with "When importing data to QPR ProcessAnalyzer, date and time data in different local times may be encountered. It's important that the times are interpreted correctly, so that th...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

When importing data to QPR ProcessAnalyzer, date and time data in different local times may be encountered. It's important that the times are interpreted correctly, so that they are comparable and for example durations between timestamps are calculated correctly.

QPR ProcessAnalyzer doesn't store the time zone differences separately, but instead uses times that have been imported to it.

When importing data with CSV file import, timestamps in CSV files may or may not have time zone information. If timestamps don't have the time zone, times are interpreted as such and they appear in the model exactly as imported. If the timestamps have the time zone information, timestamps are imported as UTC, to make timestamps with different time zones comparable with each other. It's also possible to import timestamps without the time zone in the date format ("zzz") which will ignore the time zone and import timestamps like they didn't contain the time zone information.