MySQL - get average of temperature for every 6 hours

Asked Dec 08 '22 at 06:03

Active Dec 08 '22 at 06:03

Viewed 30 times

I have created_at column in my table. Let's say data as follows-

I want to get the average of temperature of each 6 hour segment. Let's say time starts from first hour of the day. Thus, my rows will be like as follows-

Note: I am able to get average of temperature of each hour using HOUR FROM of MySQL.

Any help is appreciated. Thanks!

asked Dec 08 '22 at 06:03

Md. Khalakuzzaman Khan

2

Maybe https://stackoverflow.com/questions/5002661/how-can-i-group-time-by-hour-or-by-10-minutes could be helpful – Ahmet-Salman Dec 08 '22 at 06:07
@Ahmet-Salman seems relevant to mine quest. Let's have a look. Thanks <3 – Md. Khalakuzzaman Khan Dec 08 '22 at 06:09

MySQL - get average of temperature for every 6 hours

0 Answers0