Wednesday, February 28, 2018

Get last 30 days data in php.

select * from `tablename` where `yourdatefield` >= 
 DATE_SUB(CURDATE(), INTERVAL 30 DAY)

No comments:

Post a Comment