How to get last three month records from a table?

Question

Postgresl / mySQL / Oracle

Muhammed Sallout · Answer

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

mirza habeeb · Answer

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()))

George Dimitrov · Answer

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

ayesha kanekal · Answer

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()))

Sani Asnain Khan · Answer

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

Majed Al-jefri · Answer

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

Khawar Baig Mirza · Answer

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

Here updated is date type field

Aftab Alam · Answer

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

Mohammed Saeed Ahmed Mohammed Al-Sharabi · Answer

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

Ameen Ali Hassan Ali · Answer

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

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

How to get last three month records from a table?

Recherches Populaires

More Questions Like This