Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
2 Contributions
Ranked #72.7K
Discussions / Questions x 1
~157 People Reached
Favorite Forums
Databases x 2
Favorite Tags
mysql x 2
query x 2
sql x 2
Member Avatar for A_7
Get hours logged per month
Share on Facebook Share on Twitter Share on LinkedIn

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 …

Databases mysql query sql
Member Avatar for pritaeas
0
3
157