Only UTC timezone in UI?


#1

Redash 4.0.0.b3331 displays datetime in UTC timezone, regardless of datetime being a naive or timezone-aware. Database default timezone is not UTC, it’s Europe/Moscow (+03:00).

  1. Datetime without timezone as shown in admin:

{“rows”: [{“wat”: “2017-12-26T23:59:59.999999”}], “columns”: [{“type”: “datetime”, “friendly_name”: “wat”, “name”: “wat”}]}

is displayed in query results table UI as expected: 26.12.17 23:59

  1. Datetime with timezone as shown in admin:

{“rows”: [{“wat”: “2017-12-26T23:59:59.999999+03:00”}], “columns”: [{“type”: “datetime”, “friendly_name”: “wat”, “name”: “wat”}]}

is displayed in query results table UI in UTC 26.12.17 20:59

In both cases, CSV/XLS output is correct and gives same result as expected (with or without timezone), not UTC.

Is this expected behavior, should UI always be UTC?
I’ve inspected relevant issue/pull-requests and codebase, but I’m not sure my assumption is correct.





Timezone UI showing UTC