clickhouseSetting timezone for date/time columns
CREATE TABLE tbl1 (date DateTime('Europe/Lisbon'), col String) ENGINE = MergeTree ORDER BY date;ctrl + ctbl1name of the table to create | DateTimeset |
'Europe/Lisbon'specify timezone to use for this column as second argument | |
More of Clickhouse
- Using anyLast() with grouped data
- Get total database size
- Get year and month from date
- Inserting JSONEachRow format data into table
- List all tables from all database
- Disable logs
- Remove column from a table
- Select where date column is between dates
- Increase number of concurrent queries
- Create AggregatingMergeTree materialized view
See more codes...