mysqldatabaseheidisql

sqlQuery where timestamp is a specific date

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?

Solution

  • 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'