How To Get Last 6 Months Data In MySQL?




Hi Friends,

I am going to explain you example of how to get last 6 months data in MySQL?. You will learn MySQL query to get last 6 months data. I would like MySQL select last 6 months. This article will give you simple example of SQL query to get last 6 months data.

We will use get search how to select last 6 months from news table using MySQL. You can understand a concept of search how to take last 6 month dates from the current month in MySQL. So, we can illustrate the getting a date 6 months in the past MySQL.

You can see both example of how do I get my last 6 months data in MySQL.

Let's see bellow example:

Table: users

Solution SQL Query:



FROM `users`

WHERE DATE(created_at) >= (DATE(NOW()) - INTERVAL 6 MONTH)


I hope it will help you...