sql-date

SELECT *
FROM  `icds_customers`
WHERE  `created_from_web` =  'HQ'
AND DATE( NOW( ) ) - INTERVAL 30
DAY + INTERVAL 0
SECOND ORDER BY  `id` ASC
LIMIT 810 , 30



SELECT DATE(NOW()) - INTERVAL 7 DAY + INTERVAL 0 SECOND;

SELECT COUNT(DISTINCT `user`) FROM `tracks`
WHERE `track_time` >= ( DATE(NOW()) - INTERVAL 7 DAY + INTERVAL 0 SECOND );

SELECT COUNT(DISTINCT `user`) FROM `tracks`
WHERE `track_time` >= '2012-11-12 00:00:00'
AND   `track_time` <  '2012-11-19 00:00:00';


ref:: http://dba.stackexchange.com/questions/29444/how-to-retrieve-rows-of-different-dates-using-in-clause