clickhouseUsing dates with timezones
SELECT toDateTime(now(), 'Europe/Lisbon')ctrl + cnow()returns current date/time | toDateTimeconverts given string to DateTime |
Europe/Lisbonpass timezone to convert date/time to as a second argument | |
Usage example
SELECT toDateTime(now(), 'Europe/Lisbon')output
┌─toDateTime(now(), 'Europe/Lisbon')─┐
│ 2022-01-12 15:29:48 │
└────────────────────────────────────┘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...