Why Do My Records Show the Correct Time With the Wrong Time Zone?

Question

Why do my Mixpanel records reflect the correct time but the wrong time zone? When I query the Mixpanel API, the time field is returned in the following format: "time": 1721833628

Environment

Connector: Mixpanel

Answer

The Mixpanel API returns timestamps based on your project's time zone settings. For more information, see the Mixpanel documentation on managing your time zone.

However, the API returns the data in Unix format, representing an absolute point time. To ensure consistency, we normalize Unix-format time zones to UTC. As a result, your records may reflect the correct time but appear to use the wrong time zone.