Your query would only return topics if they were created at exactly midnight on that date. If you’re looking for topics created any time on that day, you would use something like this:
SELECT * FROM topics
WHERE created_at >= '2022-05-01'
AND created_at < '2022-05-02'