Posts by jaugusto • 1 point
1 post
-
0
votes2
answers815
viewsA: Select averaged in minutes - Mysql
I found a way to make it a little bit simpler. SELECT -- pc.hora, /* desabilite caso queira conferir */ CASE WHEN (MINUTE(pc.hora)>=0 AND MINUTE(pc.hora) <=29) THEN `0-29` ELSE `30-59` END as…