My client has a Metabase report displaying data from a Mautic database.
The time in the Mautic database is UTC.
The report label in Metabase is labeled "Timezone US/Pacific". We want the label to read “UTC”.
We tried the following with but there was no impact
Go to Admin Settings → Localization
Look for “Report Timezone”
You can change it from US/Pacific to:
UTC (to match your Mautic database)
or US/Eastern, etc.
Question: Can the Metabase label be changed?
The MySQL DATETIME data type is timezone naive. The session timezone setting will not impact the stored data or the representation returned when queried. The TIMESTAMP data type is timezone aware. If you want the database (or Metabase) to convert DATETIME into another timezone, you’ll need to cast the DATETIME type to TIMESTAMP with the appropriate syntax.
That column appears to be using Doctrine, the ‘DC2Type: datetime’ comment is a marker for Doctrine on how to interpret the column contents.
