search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
245 stars 86 forks source link

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

Closed dzmt closed 3 years ago

dzmt commented 3 years ago

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.