Selecting records from a db in a time span?

Question

SQL

Screenshot of the database prntscr.com/jcsbqo
There is such a request, but it does not select the desired values.
SELECT `ip_adreess` FROM `requests` WHERE `date_create` >= DATE_SUB(CURTIME(),INTERVAL 1 HOUR);
I need to select `ip_adreess` between current time - 1 hour, how to do it?

Answer 1

CURTIME() returns only the time, no date. Use NOW().