I am new to time manipulation or time arithmetic operations
and am currently developing a navigation system with Web server based information and currently I have this Database that contains a table peek hours whose columns are id, start_time, end_time , edge_id, day_of_the_week, edge_weight
------------------------------------------------------------------------
| Peek Hours |
------------------------------------------------------------------------
| | | | | | |
| id | start_time | end_time | edge_id | day_of_the_week | edge_weight |
| | | | | | |
------------------------------------------------------------------------
I am using PHP as a webservice and so based on the current time i want to get all the records that would fit this equation
start_time< current_time < end_time