Get current month entries

Question

How can I select the current month records from the MySql database table?

Like the current month is January. I would like to get the records for the month of January where the data type of my column is the timestamp table. I would like to know the SQL query.

thanks

Answer 1

This query should work for you:

 SELECT * FROM table WHERE MONTH(columnName) = MONTH(CURRENT_DATE()) AND YEAR(columnName) = YEAR(CURRENT_DATE()) 

Answer 2

Check MySQL Datetime Functions:

Try the following:

 SELECT * FROM tableA WHERE YEAR(columnName) = YEAR(CURRENT_DATE()) AND MONTH(columnName) = MONTH(CURRENT_DATE()); 

Answer 3

Try this query:

 SELECT * FROM table WHERE MONTH(FROM_UNIXTIME(columnName))= MONTH(CURDATE())