hawkfish/duckdb-taco

Tableau Connector for DuckDB

duckdb-taco's Issues

DATETRUNC returns DATETIME

Figured it out. DuckDB rebinds the return type for day-level truncations to DATE, but Tableau expects the return type to always be DATETIME, so it butchers the return type back to date time and messes it up depending on the system TZ. This is why adding the cast fixes the problem - the values are returned with the type Tableau expects and it leaves them alone.

This is not a DuckDB bug, but it is something I can fix in the duckdb-taco. if you are using PG dialect, then you will need to add the cast manually.

Originally posted by @hawkfish in duckdb/duckdb#7879 (comment)