Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DateTime type with timezone is interpreted as String by Tableau #352

Closed
dzmt opened this issue Apr 20, 2021 · 0 comments · Fixed by #356
Closed

DateTime type with timezone is interpreted as String by Tableau #352

dzmt opened this issue Apr 20, 2021 · 0 comments · Fixed by #356

Comments

@dzmt
Copy link

dzmt commented Apr 20, 2021

ClickHouse server version 21.2.3 revision 54447
ClickHouse ODBC version v1.1.9.20201226
Tableau Desktop version 2020.4

CREATE DATABASE test;
create table test.order ( order_datetime DateTime('UTC'), order_datetime_without_timezon DateTime ) ENGINE = MergeTree() ORDER BY (order_datetime);
INSERT INTO test.order VALUES ('2021-01-01 00:03:00', '2021-01-01 00:03:00');

DateTime without timezone is interpreted correctly.

image

Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants