Just Wondering if there is an esay way to query dates
i.e. i want to get the results for data 10 minutes ago. i am using this now but there just has to be a better way
select * from data where time >=sec_to_time(((hour(curtime())*3600)+(minute(curtime())*60) + (second(curtime())) - 600));
thanx
i.e. i want to get the results for data 10 minutes ago. i am using this now but there just has to be a better way
select * from data where time >=sec_to_time(((hour(curtime())*3600)+(minute(curtime())*60) + (second(curtime())) - 600));
thanx