lunes, 16 de febrero de 2015

Query por fecaha actual

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