Hi I want assist with a database myql query.

What where clause can one use to choose records which are 1 hour or more youthful utilizing a DATETIME timestamp?


Something similar to this? I suppose an DATETIME timestamp is definitely an DATETIME area.

SELECT * FROM table WHERE datetimefield >= DATE_SUB(NOW(), INTERVAL 1 HOUR)

To learn more check MySQL's date/time functions.