sky_revolution
asked on
MySQL WHERE & timestamp help
I have a column called "timestamp" in my mysql table, the column type is "datetime":
Example timestamp format: 2011-12-16 16:51:45
I'm trying to write a SELECT query to only select records with a timestamp within the last 20 minutes of the current time.
How would I do this using PHP?
Thanks
Example timestamp format: 2011-12-16 16:51:45
I'm trying to write a SELECT query to only select records with a timestamp within the last 20 minutes of the current time.
How would I do this using PHP?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works great, thanks!
Open in new window