Group by Time as varchar every 30 min | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
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

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