clickhouseSelect with date column values
SELECT * FROM tbl WHERE date = toDate('2022-01-12')ctrl + ctoDateconverts string to date | datedate column |
'2022-01-12'sample date to use in select | |
Usage example
SELECT * FROM tbl WHERE date = toDate('2022-01-12')output
┌───────date─┬─col────┬─val─┬─age─┐
│ 2022-01-12 │ Donald │ 0 │ 0 │
└────────────┴────────┴─────┴─────┘More of Clickhouse
- Using variables in queries
- List all tables from all database
- Convert hex to text
- Get total database size
- String concat
- Select where date column is between dates
- Select rows with certain value in array column
- Create table with UUID column
- Add row number to results
- Convert array to string
See more codes...