مطالب مرتبط با «hours in a work week» در Stack Exchange | نویسنده: رضا رضوی
Hours in a month per date range
I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration | | Aug | 10 | | Sept | 9 | I can get the right output when each record is only within 1 month but I am not sure how to go about crossing month boundaries. Can anyone point me in the right direction? Let's block ads! بخوانید...
ادامه مطلب
