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?

@Pawan.Java This can do for a quick and dirty query, but using string manipulation functions to deal with dates almost never pays off in the long term. Code becomes harder to maintain, performance suffers and it's easy for bugs to slip in. — Álvaro González
– Álvaro González, Commented Feb 21, 2022 at 10:09
@ÁlvaroGonzález I know but given the problem statement, he was looking for something quick itself. — Pawan.Java
– Pawan.Java, Commented Feb 21, 2022 at 11:34

Álvaro González · Accepted Answer · 2022-02-21 09:45:47Z

4

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'

answered Feb 21, 2022 at 9:45

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, I have modified only the last part in timestamp < DATE_ADD( '2022-02-02 ', INTERVAL 1 DAY)