// 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
Share

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

  1. FIX 1Set the report time zone

    1. 01Go to Admin > Settings > Localization
    2. 02Set Report Timezone to your business time zone
    3. 03Re-run the question
    Did this fix it?
  2. FIX 2Match the JVM time zone (self-hosted)

    1. 01Set the JAVA_TIMEZONE environment variable (or -Duser.timezone) to the database's time zone
    2. 02Restart Metabase
    Did this fix it?
  3. FIX 3Convert explicitly in SQL

    1. 01Use your database's conversion, for example column::TIMESTAMP AT TIME ZONE 'EST' in PostgreSQL
    Did this fix it?
  4. FIX 4Diagnose the offset

    1. 01Drill into a day you know is wrong
    2. 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 us

Watch Metabase Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

Other Metabase errors

All 14 Metabase errors and fixes →