Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

I need Time Wise summary Report in mysql

Home
Forums
Oracle

I need Time Wise summary Report in mysql

snowal raj

snowal raj

9yAsked Feb 3, 2017, 4:02 AM1kOracle

hai,

I have some data like

Date	Amount
30-01-2017 19:07:46	10
30-01-2017 19:08:52	20
30-01-2017 19:15:10	65
30-01-2017 19:16:58	85
30-01-2017 19:17:13	48
30-01-2017 19:20:05	165
30-01-2017 19:20:29	15
30-01-2017 19:38:53	98
30-01-2017 19:40:15	35
31-01-2017 21:45:18	56
31-01-2017 21:46:22	58
31-01-2017 22:05:27	12
31-01-2017 23:54:49	5
31-01-2017 23:55:53	84
31-01-2017 23:56:49	41
31-01-2017 23:59:01	65

And I need result using mysql in this format

Time Intervel	Amount
19:00:00-20:00:00	541
20:00:00-21:00:00	0
21:00:00-22:00:00	114
22:00:00-23:00:00	12
23:00:0-00:00:00	195

Please Help,

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Nitin Sontakke9y ago
Accepted answer
In the output end time is coming again as start time of next row, which would be incorrect.

You are better of having output as

19:00:00 - 541
20:00:00 - 0

etc.

For display purpose you can print it as follows:

19:00:00 - 19:59:59 - 541
20:00:00 - 20:59:59 - 0

If this is acceptable, you are better of, just by grouping by the hour part of the day and you are done.
+1
Suvendu Shekhar Giri9y ago
Have you already tried any query for this?
0