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 Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.