Hi,
I have 2 queries from 2 different data sources were I want to group data weekly.
One works fine
but second (just in case I’ve add ‘to_date’ formating)
gives error
Please advice!
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
mmovchan
1
mali
2
Hi, Welcome
Are both data sources same? It seems like date_trunc function is not available in database you are hitting.
mmovchan
3
I use 2 different data sources. 2nd one is clickhouse. Is there any other way to apply this function?
jesse
4
Clickhouse uses a different syntax than normal SQL. Their documentation explains how to handle datetime values. If you would date_trunc('month', ...) in normal SQL you would use toStartOfMonth in Clickhouse.