// troubleshooting guide · metabase
Metabase Dates and Times Wrong (Timezone Off)
- Status
- Workaround available
- platforms:
- Metabase Cloud, self-hosted
- updated:
- November 16, 2026
- reports:
- 3
- Method
- how we research
RUNBOOK · metabase/wrong-timezone4 FIXES
// quick answer
Dates shift by hours or a whole day when Metabase's report time zone, the JVM time zone and the database's time zone don't line up. Set the report time zone in Admin > Settings > Localization, or match the JVM time zone to the database.
Most likely fix: Set the report time zone
How to fix it
// try these in order, the most common fix is first
FIX 1Set the report time zone
- 01Go to Admin > Settings > Localization
- 02Set Report Timezone to your business time zone
- 03Re-run the question
Did this fix it?FIX 2Match the JVM time zone (self-hosted)
- 01Set the JAVA_TIMEZONE environment variable (or -Duser.timezone) to the database's time zone
- 02Restart Metabase
Did this fix it?FIX 3Convert explicitly in SQL
- 01Use your database's conversion, for example column::TIMESTAMP AT TIME ZONE 'EST' in PostgreSQL
Did this fix it?FIX 4Diagnose the offset
- 01Drill into a day you know is wrong
- 02Shift the filter by hours and compare the offset to the database and Metabase time zones
Did this fix it?
SANDBOX · metabase RUNS IN YOUR BROWSER
Try it: browse a sample shop and watch visitors, funnels and live data arrive
A hands-on Metabase-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.
Symptoms
Charts show totals on the wrong day, date filters are off by one day, or timestamps are several hours off.
Why it happens
- C-01Metabase time zone differs from the database server's
- C-02Database ignores the session time zone Metabase sets
- C-03Date-only fields grouped without a time zone
- C-04Mixing timestamps with and without time zones in one question
- C-05Different JVM time zone in Docker or Kubernetes than on a local JAR
// this guide also covers
- metabase timezone wrong
- metabase date off by one day
- metabase report timezone
- metabase dates wrong
Still not working?
If Metabase keeps failing, you're not alone. See every Metabase problem users report or the alternatives people switch to.
Done fighting Metabase? Our small team builds your own Metabase alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usOther Metabase errors
- Metabase Dashboard Slow or Not Loading
- Metabase 'Your Question Took Too Long' Error
- Metabase Not Syncing New Tables or Columns
- Metabase Filter Dropdown Not Showing Values
- Metabase Linked Filters Not Working
- Metabase Not Sending Emails or Alerts
- Metabase Can't Connect to Database
- Metabase Tables Not Showing