TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Bug Report: ClickHouse incorrectly display Date32 (and possibly Date64)

Open FoxyBOA opened this issue 1 year ago • 0 comments

ClickHouse Server Version:

  • 24.12.2.29
  • Tested also with 24.8.4.13

TablePlus Version:

  • 6.1.1 (Build 278) x64

Issue Description

When querying Date32 values, the results are displayed incorrectly. For example, the following SQL query:

SELECT toDate32('1956-02-12');

Expected Result:

1956-02-12

Actual Result:

2106-02-07

This issue does not occur when using the ClickHouse HTTP Play client, which returns the correct value (1956-02-12). Additionally, the macOS version of TablePlus also displays the value correctly.

FoxyBOA avatar Jan 13 '25 10:01 FoxyBOA