brownheezo
Programmer
Is there any way of saying "tem minutes ago"?
Example:
select userID from users where joined = NOW() - 1000
I'm trying to say give me all of the users that joined exactly 10 minutes ago. This would work for most cases if you were using timestamp, but if it's January 1, 2004 12:00AM, it won't get the proper results.
I could do it in PHP, but I'm trying to stay away from it.
Any tips, or hidden functions that I should know about?
Thanks in advance
Example:
select userID from users where joined = NOW() - 1000
I'm trying to say give me all of the users that joined exactly 10 minutes ago. This would work for most cases if you were using timestamp, but if it's January 1, 2004 12:00AM, it won't get the proper results.
I could do it in PHP, but I'm trying to stay away from it.
Any tips, or hidden functions that I should know about?
Thanks in advance