DEV Community

Techsolutionstuff
Techsolutionstuff

Posted on • Originally published at techsolutionstuff.com

How To Get Current Month Records In MySQL Query

In this article, we will see how to get current month records in MySQL query. For data analysis and reporting, we need more data or records. So, we will learn how to get current month data in MySQL PHP. For getting data for the current month in MySQL we use the month() function. MySQL month() returns the month number for a given date. The return value is from 1 to 12.

So, let's see SQL query to get current month data and how to get current month data in PHP from MySQL Database.

Get Current Month Data In MySQL Example:

In this example, we will see an SQL query to get data for the current month in MySQL.

id order_date amount Orders
1 2022-02-01 150 2
2 2022-02-02 200 4
3 2022-03-03 100 1
4 2022-03-04 300 5
5 2022-04-05 200 3
7 2022-04-06 190 7

In your table, the record needs to be like date and month.

select * from users
       where MONTH(order_date) = MONTH(now())
       and YEAR(order_date) = YEAR(now());
Enter fullscreen mode Exit fullscreen mode

In the above query, we use the now() function to get the current date, and the month() function to get the current month number of date values.

How to Get New Users in the Current Month in MySQL

Using the below MySQL query you can get the new users in the current month with date and count.

select date(created_at), count(*) from users
       where MONTH(created_at) = MONTH(now())
       and YEAR(created_at) = YEAR(now())
       group by date(created_at);
Enter fullscreen mode Exit fullscreen mode

Get the current month using the MONTH() function.

SELECT MONTH(CURDATE());
Enter fullscreen mode Exit fullscreen mode

Output:

Current Month: 9
Enter fullscreen mode Exit fullscreen mode

Top comments (0)