2808 explained code solutions for 75 technologies


clickhouseSelect with date column values


SELECT * FROM tbl WHERE date = toDate('2022-01-12')ctrl + c
toDate

converts string to date

date

date 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 │
└────────────┴────────┴─────┴─────┘