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 array to rows
- Get total database size
- How to execute SQL query from a file
- How to restart Clickhouse server
- List all tables from all database
- Using variables in queries
- Select where date column is between dates
- Select countIf usage example
- Select sumIf query example
- Get table size
See more codes...