Mr Chris Posted July 24, 2009 Share Posted July 24, 2009 Hello, I have a query whereby I want to check if an IP address has a record in the database that has been added within the last 10 minutes: However as you will see from the above I ran this query at 2009-07-24 12:44:00 which is more than 10 minutes after 2009-07-24 12:22:47 and a result is returned - why would that be? Quote Link to comment Share on other sites More sharing options...
rhodesa Posted July 24, 2009 Share Posted July 24, 2009 date_time will always be less then now, especially if you ADD 10 minutes to it. you want to check if date_time is GREATER then now MINUS 10 minutes Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.