Okay, I need help with this one:

I have a table with a column in the MySQL DATETIME format.  (2001-07-24

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))


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]

Reply via email to