Group by Time as varchar every 30 min | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Group by Time as varchar every 30 min

I’ve column Time > type varchar hhmmss I want to count every 30 minutes 010000 1 010100 2 013000 2 013200 3 Excepted output 01:00 5 01:30 3

querydboracel
23rd Mar 2020, 12:17 PM
Ghaida
Ghaida - avatar
1 Answer
+ 1
maybe two grouping steps: first hour, than minute.
24th Mar 2020, 6:57 AM
Oma Falk
Oma Falk - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Python Question
3 Votes
How to learn fast C?
0 Votes
Hi everyone! I want change div with name "cd" to text(how to add url here)when I click button. No my code not worked. help me.
1 Votes
Initials of name
1 Votes
Hello, please help me understand how to solve
0 Votes
Why are the outputs appeared different?
1 Votes
How to synchronize android studio
0 Votes
I want these three dots to jump inside that box..please help
1 Votes
Forever loop pls help
0 Votes
Css In python
0 Votes