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
1 Answer
+ 1
maybe two grouping steps:
first hour, than minute.
Often have questions like this?
Learn more efficiently, for free:
Hot today
Is this realistic enough?
1 Votes
"Whatās the best way to combine creativity and coding? Can storytelling improve web apps?"
1 Votes
Need friends
0 Votes
Python
1 Votes