Group by Time as varchar every 30 min | Sololearn: Learn to code for FREE!
Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula grƔtis
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 Resposta
+ 1
maybe two grouping steps: first hour, than minute.
24th Mar 2020, 6:57 AM
Oma Falk
Oma Falk - avatar