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
- Convert datetime to unix timestamp
- Convert hex to text
- Select rows with certain value in array column
- Select where date column is between dates
- Create table example
- Using variables in queries
- List all tables from all database
- Add row number to results
- Create table with UUID column
- Insert array of strings in CSV format
See more codes...