How to get last three month records from a table?

SELECT * FROM `test` WHERE c5 >= DATE_SUB( CURDATE(), INTERVAL3 MONTH ) You can test this query online from the website, http://demo.phpmyadmin.net/STABLE/sql.php?db=a1&table=test&server=2&target=&token=e7563fb5c16bd1466#PMAURL-1:tbl_sql.php?db=a1&table=test&server=2&target=&token=e7563fb5c16bd1466

SELECT * FROM Member WHERE DATEPART(m, date_created)= DATEPART(m, DATEADD(m,-1, getdate()))AND DATEPART(y, date_created)= DATEPART(y, DATEADD(m,-1, getdate()))

table.date BETWEEN trunc((trunc(sysdate,'mm')-1),'mm') AND trunc(sysdate,'mm')-1 Or you can check TO_DATE function

SELECT*FROM Member WHERE DATEPART(m, date_created)= DATEPART(m, DATEADD(m,-1, getdate()))AND DATEPART(m, date_created)= DATEPART(y, DATEADD(m,-1, getdate()))

try it .
http://stackoverflow.com/questions//display-record-older-than-3-months-in-sql

where to_date(year || month,'YYYYMM')between add_months(trunc(sysdate,'MM'),-3)and trunc(sysdate)

select * from rt_trans where updated >= trunc((select max(updated) from rt_trans)-interval '3' month)

Here updated is date type field

select *from table_name where to_date(to_char(columnName,'MM/DD/yyyy'),'MM/DD/yyyy')  between  fromDate and ToDate;

SELECT * FROM table WHERE date >= DATE_SUB(CURDATE(), INTERVAL3 MONTHS) الفكرة في الشرط ان يكو تاريخ التسجيل اكبر او يساوي التاريخ الحالي ناقص ثلاثة اشهر date >= Date_now -3months

الامر يتعلق بالاستعلام عن بيانات بشرط انها ادخلت في الفتره من الان الاى ثلاثه شهور ماضيه