Returning records from the last 3 months only in MySQL
mysql
Solution
3 months before today:
select * from table where timestamp >= now()-interval 3 month;
Start with first of month:
select * from table where timestamp >= last_day(now()) + interval 1 day - interval 3 month;
Problem
I have a table with a timestamp field. How do I get data from the last 3 months? In particular, March is my current month let say, 03/2012. I need to return records from the months March, February, and January only.