Dynamic timezone for hour display on postgreSQL

Get Help
1

Hi,

I have a postgreSQL table with a date column and a hour column.
Date column is type date and time column (HH:MM:SS) is type varchar.
Assumming hour column is stored in UTC time: Would it be possible to offer metabase reports in a dynamic timezone depending on the location of the viewer?

thanks,

2

Hi @eclar
It would be impossible for Metabase to handle string-based columns without conversion, so Metabase can interpret and manipulate it.
But there's currently not user-based timezone support:
https://github.com/metabase/metabase/issues/4284 - upvote by clicking :+1: on the first post

3

And how should it be the type of the column to allow viewer defined timezone conversion in metabase?

4

@eclar Whenever issue 4284 is implemented, then it would require timestamp based columns with timezone for Metabase to be able to do any manipulation on those.
In other words, it's currently not possible to have Metabase do exactly what you are asking for.
You would currently have to include a filter, where a timezone can be inputted and then you'll need to do the manipulation in SQL.

1 Like
5

Hi again @flamber

I'm trying to use

image
image847×384 34.9 KB

But I can't use it
image
Any ideas?

6

@eclar Post "Diagnostic Info" from Admin > Troubleshooting.

7 
{
  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.15+10",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.15",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.15+10",
    "os.name": "Linux",
    "os.version": "5.4.204-113.362.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "redshift"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.8"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.3.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-06-27",
      "tag": "v1.43.4",
      "branch": "release-x.43.x",
      "hash": "61cc28e"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
8

@eclar If you are a Pro/Enterprise customer, then please use the support email.
You are showing a screenshot for the v45 documentation, which implemented convertTimezone().