1 day interval

[rashmi_k28]

How to find the records from current time to the 1 day interval excluding the seconds of the timestamp

[paul2463]

have alook <A HREF="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html"> Here at the MYSql Manual</A>

 

SELECT something FROM tbl_name WHERE date_column = DATE_SUB(CURDATE(),INTERVAL 1 DAY) 

 

 

[rashmi_k28]

select timestamp, ifnull(avg(100 - pkt),-1) from tablename where timestamp <= ('".$time."') and timestamp >= date_sub('".$time."',interval 1 day) group by timestamp;

 

But I should include minutes and hour along with date.

 

Now i am using the query like this