sandy1028 Posted February 25, 2008 Share Posted February 25, 2008 Hi, I have to select the records of 24hrs value from current timestamp. The values are in database which is sampled for 10 minutes. So the Hour and minutes will be equal As the seconds differ in the database the values are not exact. Sometimes I get 144 records and sometimes 143. How to select records from the database excluding seconds. select timestamp, count(*) cnt from nodes_details where status = 1 and timestamp >= ('".$time1."') and timestamp <= ('".$time."') group by timestamp order by timestamp Link to comment https://forums.phpfreaks.com/topic/92863-timestamp-if-24hrs/ Share on other sites More sharing options...
fenway Posted February 25, 2008 Share Posted February 25, 2008 Why not check if a given interval is > 24hrs? Link to comment https://forums.phpfreaks.com/topic/92863-timestamp-if-24hrs/#findComment-475733 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.