Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
07-07-2011, 09:49 AM #1
- Join Date
- Aug 2010
- Thanked 0 Times in 0 Posts
TIMESTAMPDIFF-Where am i going wrong?
Hi I'm trying to select from my downloads table users who havent downloaded for 20 mins.
My download table:
jeff, 001.jpg, 2011-07-06 16:08:38
barry, 004.jpg, 2011-07-06 16:09:36
SELECT * FROM 'downloads' WHERE TIMESTAMPDIFF(MINUTE,CURRENT_TIMESTAMP,time)>20;