Miscellany

mysql> select curdate();
+------------+
| curdate()  |
+------------+
| 2011-06-07 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM cdr WHERE calldate = curdate();
Empty set (0.00 sec)

mysql> SELECT * FROM cdr WHERE calldate >= curdate() Limit 1;
+---------------------+------------+------------+------------+----------+-----------+------------+---------+----------+----------+---------+-------------+----------+-------------+-----------+
| calldate            | clid       | src        | dst        | dcontext | channel   | dstchannel | lastapp | lastdata | duration | billsec | disposition | amaflags | accountcode | userfield |
+---------------------+------------+------------+------------+----------+-----------+------------+---------+----------+----------+---------+-------------+----------+-------------+-----------+
| 2011-06-07 00:22:48 | xxxxxxxxxx | xxxxxxxxxx | xxxxxxxxxx | jpl-efax | DAHDI/1-1 |            | Hangup  | 2        |        5 |       5 | ANSWERED    |        3 |             |           |
+---------------------+------------+------------+------------+----------+-----------+------------+---------+----------+----------+---------+-------------+----------+-------------+-----------+
1 row in set (0.00 sec)