toStartOfMonth(NOW()) return "January 31, 2024 " - Githubissues

ClickHouse / metabase-clickhouse-driver

ClickHouse database driver for the Metabase business intelligence front-end

Apache License 2.0

461 stars 84 forks source link

toStartOfMonth(NOW()) return "January 31, 2024 " #223

Closed bladexxx closed 5 months ago

bladexxx commented 5 months ago

Describe the bug

Metabase Version You're on version v0.47.9 Built on 2023-12-01

Clickhouse Version: 22.8 (22.8.21.38)

Steps to reproduce

open "SQL query" in metabase
choose clickhouse database
input sql: select toStartOfMonth(NOW())
return "January 31, 2024 "

Expected behaviour

it should return Feb 1, 2024.

Error log

Configuration

Environment

metabase-clickhouse-driver version: 1.2.5
metabase-clickhouse-driver configuration:
Metabase version: v0.47.9
OS:CentOS7

ClickHouse server

ClickHouse Server version: 22.8.21.38
ClickHouse Server non-default settings, if any:
CREATE TABLE statements for tables involved:
Sample data for all these tables, use clickhouse-obfuscator if necessary

bladexxx commented 5 months ago

docker timezone issue leads to this issue. so closed it.