clickhouseGet current server timezone
Usage example
SELECT timezone()output
┌─timezone()────┐
│ Europe/Lisbon │
└───────────────┘More of Clickhouse
- Using anyLast() with grouped data
- Select where date column is between dates
- List all tables from all database
- Get year and month from date
- List all users
- Remove column from a table
- Get total database size
- How to use regex in queries
- How to execute SQL query from a file
- Export table to CSV file
See more codes...