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)