clickhouse-odbc icon indicating copy to clipboard operation
clickhouse-odbc copied to clipboard

Implement timezone normalization and consistent handling for DateTime types

Open traceon opened this issue 3 years ago • 0 comments

  • Consider adding a parameter, that controls, whether the dates/times should be converted to some target timezone at all or the server/column timezone should be used, when presenting data in ODBC timestamp etc. data structures, that are timezone-unaware.
  • Implement timezone conversion for all formats. All the machinery is ready, only the conversion should be implemented. Currently, RowBinaryWithNamesAndTypes is not consistent with ODBCDriver2. See:
    • https://github.com/ClickHouse/clickhouse-odbc/blame/master/README.md#L112
    • DateTime tests (all tests should not depend on server or local timezones and wire formats)
    • WireTypeDate***AsInt structs and their conversion methods.

traceon avatar Jul 24 '21 21:07 traceon