Av@Tech India 22 Questions 29 Answers 1 Best Answer 84 Points View Profile 0 Av@Tech Learner Asked: June 24, 2020In: Daily Coding Problems How to select record from last 6 months in a table using MySQL? 0 I want to get the last 3-6 months’ records from fund_master table. date_payment is the date type column. MysqlPHP Share Facebook 1 Answer Voted Oldest Recent Random WebGuru India 12 Questions 130 Answers 2 Best Answers 290 Points View Profile WebGuru Explainer Added an answer on June 24, 2020 at 12:44 pm You can use DATE_SUB() to get the last 6 months’ records. select * from fund_master where date_payment BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 90 DAY ) AND CURDATE( ) ; 0 Reply Share Share Share on Facebook Share on Twitter Share on LinkedIn Share on WhatsApp Leave an answerCancel replyYou must login or register to add a new answer.