sqlQuery where timestamp is a specific date

Question

Hy guys I have this table: VisitedCity

id	timestamp	name	city
1	2022-02-02 10:02:23	Mark	LA
2	2022-01-15 08:45:01	Phil	NY
3	2022-02-05 11:09:45	John	MI

My query :

SELECT * FROM VisitedCity
WHERE timestamp = '2022-02-02'

But it doesn't return any rows. How Could I do it?

Answer 1

You can't use = if you don't want an exact match. You need to query for an interval:

SELECT *
FROM VisitedCity
WHERE timestamp >= '2022-02-02 00:00:00' AND timestamp < '2022-02-03 00:00:00'