12 lines
409 B
MySQL
12 lines
409 B
MySQL
|
select
|
||
|
|
extract('day' from time)::varchar || '.' || extract('month' from time)::varchar || '.' || extract('year' from time)::varchar as day,
|
||
|
|
avg(temperature)::numeric(10,0) as temperature
|
||
|
|
from room_climate_measurement_t
|
||
|
|
where
|
||
|
|
category = 'Outdoor' and
|
||
|
|
location = 'Outdoor' and
|
||
|
|
extract('hour' from time) = 12 and
|
||
|
|
time::date = now()::date
|
||
|
|
group by day
|
||
|
|
|