mysql> select count(*) as calls,dcontext as ivr,month(now()) as month ,dayofmonth(now())as day from cdr where dcontext='ivr_5' and month(calldate)=month(now()) and dayofmonth(calldate)=dayofmonth(now());
+-------+-----+-------+------+
| calls | ivr | month | day |
+-------+-----+-------+------+
| 0 | NULL | 2 | 16 |
+-------+-----+-------+------+
1 row in set (0.16 sec)
calldate es dnde estan las fechas
No hay comentarios:
Publicar un comentario