How to find data between specific range of dates
number_used allocation_date deallocation_date
1 1-4-2013 00:00:00 5-4-2013 00:00:00
2 6-4-2013 00:00:00 10-4-2013 00:00:00
3 11-4-2013 00:00:00 15-4-2013 00:00:00
1 16-4-2013 00:00:00 20-4-2013 00:00:00
This is my table in mysql database. There are three columns with no unique
values. 1 number is used between date 1-4-2013 to 5-4-2013 and other
likewise. How can I find out the number_used between dates 2-4-2013 to
14-4-2013?
No comments:
Post a Comment