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).
- 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
- 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.