User configuration for date/time format & default timezone

[arikfr]

See #617 and #411 for more details.

[karlgrz]

Any priority on this issue? We have to convert DD/MM/YYYY to MM/DD/YYYY manually ourselves, which is a bit annoying. Our queries return time in MM/DD/YYYY, as confirmed by looking at our redash db.

[arikfr]

If all your users need MM/DD/YYYY, then you can change it in the global configuration (by adding the REDASH_DATE_FORMAT environment variable).

[karlgrz]

@arikfr fantastic tip, thank you! Works beautifully.

[jeffwidman]

In the Docker environment, where do I set this REDASH_DATE_FORMAT ?

[arikfr]

@jeffwidman it's an environment variable you need to set. If you use Docker Compose, then it's in the environment section of the YAML file.

[deecay]

I get a lot of request for absolute-time display.
Not "13 days ago" but "4 May 2016" instead.

Proposal:

1. Replace all occurrences of span am-time-ago to rd-time-ago.
2. Introduce new env variable REDASH_ABSOLUTE_DATE and make rd-time-ago respect that.

[arikfr]

@deecay I prefer not to complicate things too much, here's an alternative: show absolute time when hovering over the relative one.

[deecay]

How about relative AND absolute shown together? Often too long and ugly?

[arikfr]

too long...

[deecay]

Yeah, it is.

I can live with hover solution.

How about my 1st proposal? I assume am-time-ago and rd-time-ago are interchangeable. Are you thinking of refactoring to one way, or are they separate for a reason?

[RichardJohnn]

Is user configuration for default timezone on the radar?

In our case it'd be too much to ask the user to think in terms of UTC and adjust the time for us. This means I can't reliably interpret a $humanTime like "yesterday 5am".

[JohnGnotek]

No answer to RichardJohnn's question? I think many of us could use that answer.

[YDKK]

Hi.
Is there any way to configure dateTimeFormat manually?

I'd like to see seconds or milliseconds in the result of query.
It seems like set by here.
I think it would be better if dateTimeFormat can be configure from environment variable like REDASH_DATE_FORMAT.

[RichardLitt]

At the moment, this isn't on the immediate radar. However, we would love to have help on this issue. I'm tagging this as help-wanted: if someone wants to jump in with a possible PR, we'd gladly look at it.

[itssimon]

@arikfr Is there any chance that the implementation of proper timezone support (with a user or organization setting) will be considered soon? I think this is an incredibly important feature to have for our users.

[dobesv]

If you want this you will have to implement it yourself and submit a pull request for it.

Ideally I think it would use the browser's time zone instead of requiring a setting.

[azundo]

I would vote against doing this based on a browser timezone. Many organizations have now gone fully remote and have staff spread across timezones. I would prioritize making query results consistent across users vs individual localization. Metabase's model fits our use case well where we can set an install-level timezone and the query engine both sets the sessions timezone properly (so date_trunc on timestamps with timezones works as expected out of the box) and display is consistent across all users. We're definitely having to fight a lot more with redash when aggregating metrics by day/month/etc.