Estacion Meteo-UV:Velocidad de Viento |
|
| Informe Gráfico de datos del día |
Error!
Query:
select c.fecha as si_fecha_local,'UVMETVV' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-01' and date(fecha)<='2026-01-01' group by date(fecha),hour(fecha)) as c left join (select s_cod as s_cod, concat(substring(si_fecha_local,1,14),'00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='UVMETVV' and date(si_fecha_local)>='2026-01-01' and date(si_fecha_local)<='2026-01-01'
group by date(si_fecha_local),hour(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
|
Error!
Query:
select c.fecha as si_fecha_local,'UVMETVV' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-01' and date(fecha)<='2026-01-31' group by date(fecha)) as c left join (select s_cod as s_cod, concat(date(si_fecha_local),' 00:00:00') as si_fecha_local, min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='UVMETVV' and date(si_fecha_local)>='2026-01-01' and date(si_fecha_local)<='2026-01-31'
group by date(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
|
Error!
Query:
select c.fecha as si_fecha_local,'UVMETVV' as s_cod, si.imin as imin,si.iprom as iprom,si.imax as imax from (select * from xcalendario where date(fecha)>='2026-01-01' and date(fecha)<='2026-12-31' group by year(fecha),month(fecha)) as c left join (select s_cod as s_cod, concat(substring(date(si_fecha_local),1,8),'01 00:00:00') as si_fecha_local,
min(si_min) as 'imin',avg(si_prom) as 'iprom', max(si_max) as 'imax'
from sensor_informe_2026
where s_cod='UVMETVV' and date(si_fecha_local)>='2026-01-01' and date(si_fecha_local)<='2026-12-31'
group by year(si_fecha_local),month(si_fecha_local)
order by si_fecha_local
limit 0,50000) as si on c.fecha=si.si_fecha_local
Error message:
Table 'uvmet.sensor_informe_2026' doesn't exist
|
|
