9951 explained code solutions for 126 technologies


clickhouseSetting timezone for date/time columns


CREATE TABLE tbl1 (date DateTime('Europe/Lisbon'), col String) ENGINE = MergeTree ORDER BY date;ctrl + c
tbl1

name of the table to create

DateTime

set DateTime type of date column

'Europe/Lisbon'

specify timezone to use for this column as second argument