What time zone does the Report Data Warehouse use?
- Autotask PSA
When querying information in the Report Data Warehouse, it may appear at first glance that the time information is incorrect. However, this is not the case.
The Report Data Warehouse stores and returns all time data in Coordinated Universal Time or Universal Time Coordinated (UTC) format. We do not change the time zone used for storage of data on our servers, so we recommend that you pull the data down and convert it locally or via the software platform of your choice. The time information displayed by the Autotask Web UI in the user's local time follows this same principle - it is stored in UTC and then converted when fetched by the system.
NOTE: The switch to Daylight Saving Time does not affect UTC. It refers to time on the zero or Greenwich Meridian, which is not adjusted to reflect changes either to or from Daylight Saving Time.