mysql hour | JAMSHID HASHIMI

December 26, 2011December 26, 2011 on MySQL tagged mysql hour, mysql time

How to get data which is added between hours in MySQL?

SELECT * FROM TABLE WHERE HOUR(time) BETWEEN 1 AND 2;

1	SELECT * FROM TABLE WHERE HOUR(time) BETWEEN 1 AND 2;

This query brings all records between 1 and 2 o’clock according to time field of you table. (time = The DB field which you save the time)