Hi,
I have a query like this
select timestamp, name from table where timestamp <= ('".$time."') and timestamp >= date_sub('".$time."',interval 1 day) group by timestamp order by timestamp.
All the records between these are fetched due to seconds in the timestamp.
The timestamp is difference of 10 minutes and seconds can be 01 or 02 so on.
Due to this seconds difference the value fetched is less by 1 for the day.
How to exclude the seconds and query for the 1 day interval difference
