I would like to calculate total order amount in the previous month.
I got the query for getting the data for the present month from the current date.
SELECT SUM(goods_total) AS Total_Amount FROM orders
WHERE order_placed_date >= date_sub(current_date, INTERVAL 1 MONTH);
Now how can I get Previous Months Data only, excluding this month.
For e.g. This month (July) I made $15,000 and last Month(June) i made $14,000.
I get the $15,000 by running the above query.
But i dont know how to calculate Previous Months.
解决方案
Here you go, use this to get the date between the 1st of last month and the last of last month in MySQL:
... order_placed_date BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00')
AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')