Thursday, December 6, 2012

How to select past 7 days records from MySQL


SELECT * FROM tablename.user_stats where upadtedDate between '2012-11-18' and '2012-12-6' and loginId=2

SELECT * FROM tablename.user_stats where upadtedDate BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE()


No comments:

Post a Comment