CODEWITHSUNDEEP
mysqlsql
Ram
Ram

Reputation: 35

Trying to get data of last three months

I am trying to find out how many times Kiln stopped in last three months. I have the following query:

SELECT SUM(kiln_no_stops) from monthly_report 
where date BETWEEN DATE_FORMAT(NOW() - INTERVAL 3 MONTH, '%m-%Y') 
AND DATE_FORMAT(NOW() , '%m-%Y')

When I use this query I get this error

Unknown column 'date' in 'where clause'.

But I am able to get the data for last one month using the query below:

SELECT SUM(kiln_no_stops) 
from monthly_report 
where date_format(yesterday,'%m-%Y')=Date_format(NOW() - INTERVAL 1 MONTH,'%m-%Y')

How can I get the data "Total number of stops" for the last three months?

Upvotes: 2

Views: 119

Answers (1)

ngrashia
ngrashia

Reputation: 9894

Check if this would help you:

SELECT SUM(kiln_no_stops) 
from monthly_report 
where yesterday >= now()-interval 3 month;

EDIT:

To get last 3 months data (March1 to May31, current date = June 18)

SELECT SUM(kiln_no_stops) 
from monthly_report where month(yesterday) < month(now())
AND yesterday >= cast( (last_day(now()) + interval 1 day - interval 4 month) as date);

Upvotes: 1

Related Questions