Skip to content

Instantly share code, notes, and snippets.

@theruziev

theruziev/clickhouse.sql

Last active June 21, 2019 15:35
Show Gist options
  • Save theruziev/88e1043dec8496f16c223eac1e5224ef to your computer and use it in GitHub Desktop.
Save theruziev/88e1043dec8496f16c223eac1e5224ef to your computer and use it in GitHub Desktop.
Download ZIP
Clickhouse TIPs
Raw
clickhouse.sql
# Range date
SELECT toDate(toStartOfDay(toDate(toUnixTimestamp(now()) + (number * 86400)))) date FROM numbers(10);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment