Stack Exchange
درباره سایت
آخرین مطالب
- DB architecture: What if a table is part of another table
- remote distribution database - Agent message code 21482. sp_MShelp_repl_agent can only be executed in the "distribution" database
- How can i open this .sbf file?
- Find the violated index on ORA-00001 (dup_val_on_index)
- How does PolyBase collect statistics from external tables?
- SQL Joins : How can i get latest record from 2nd table (one to many relationship)
- This Error appear when trying to attach database
- Hours in a month per date range
- mysqli error: [1093: ...]
- Actual Row Size vs My Estimated Row Size - SQLServer
امکانات وب
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?
برچسب: hours in a year,hours in a week,hours in a month,hours in a work year,hours in a day,hours in a work week,hours in a day on mars,hours in a month average,hours in a work month,hours in a school year,
نویسنده: رضا رضوی