Okay, I need help with this one:
I have a table with a column in the MySQL DATETIME format. (2001-07-24
13:02:02)
I need a MySQL query that will select all the entries in it made within the
last hour.
I tried this, but it is not working correctly, what am I doing wrong?
SELECT *
FROM session
WHERE (session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR))
Thanks!!!
Ryan Shrout
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]