Red informatica CEAZA CEAZA CEAZA-Met  
Slideshow Image 1 Slideshow Image 1 Slideshow Image 1 Slideshow Image 1
  Herramientas


Ver preferenciasPreferencias
de Usuario
Sensores Disponibles
 
 
 
                 

   
Error in SQL query: ERROR: date/time field value out of range: "2019-02-29 00:00:00" LINE 1: ...al_horas from calendario_hora where ch_fechahora>='2019-02-2... ^ Query:select *,('TILRS∫ervalodia') as s_cod,(coalesce(cant_horas*(24/24),0)*100/cant_total_horas) as data_pc from (select ch_fechahora as fecha,1 as cant_total_horas from calendario_hora where ch_fechahora>='2019-02-29 00:00:00' and ch_fechahora<='2019-02-29 23:59:59' order by fecha) as qhora1 left join (select min(si_fecha_gmt4) as si_fecha_gmt4,min(si_min) as si_min,avg(si_prom) as si_prom,max(si_max) as si_max,sum(cant) as cant_horas from (select 'TILRS∫ervalodia' as s_cod,min(si_fecha_gmt4) as si_fecha_gmt4,min(si_min) as si_min,avg(si_prom) as si_prom,max(si_max) as si_max,1 as cant from sensor_informe_x_1 where s_cod='TILRS∫ervalodia' and si_fecha_gmt4>='2019-02-29 00:00:00' and si_fecha_gmt4<='2019-02-29 23:59:59' and si_min<>'NaN' and si_prom<>'NaN' and si_max<>'NaN' and si_estado < 2 group by date (si_fecha_gmt4),extract (hour from si_fecha_gmt4)) as si group by date(si_fecha_gmt4),extract (hour from si_fecha_gmt4) order by si_fecha_gmt4) as qhora2 on date(qhora1.fecha)=date(qhora2.si_fecha_gmt4) and extract (hour from qhora1.fecha)=extract (hour from qhora2.si_fecha_gmt4)