How can I get the rows in which the date is in the interval of the past hour?

Question

MySQL

How can I get the rows in which the date is within an hour? This format: 2017-09-06 07:27:08.

Answer 1

SELECT *
FROM foo
WHERE date BETWEEN DATE_SUB(NOW(), INTERVAL 1 HOUR) AND NOW()