I have my database structure like this:
id | start | end |
---+-----------------+-----------------+
1 |2016/01/01 10:00 |2016/01/10 09:45 |
---+-----------------+-----------------+
2 |2016/01/03 15:30 |2016/01/17 22:35 |
---+-----------------+-----------------+
3 |2016/01/12 17:15 |2016/01/20 11:20 |
...
I want to find a range of these two dates in days and sum all the days. Maybe anyone has a solution?
use select DATEDIFF(dateField1, dateField2) as dateInDays from yourTable http://www.w3schools.com/sql/func_datediff_mysql.asp