/SQL/Current month mysql query

Current month mysql query

This month mysql where

SELECT *
FROM table 
WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());

1

Source: stackoverflow.com

Get month from database php

echo 'Day' . date('d', strtotime($row['Date']));
echo 'Month' . date('m', strtotime($row['Date']));
echo 'Year' . date('Y', strtotime($row['Date']));

1

Source: stackoverflow.com

Current month mysql query

SELECT 
    * 
FROM `users` 
WHERE MONTH(created_at) = MONTH(now())
   AND YEAR(created_at) = YEAR(now())

0

Source: nicesnippets.com

Similar codes

0 vote142 views2 answers
Sql query in dax power bi
SQL
0 vote135 views1 answer
Mysql select where field like in list
SQL
2 votes142 views1 answer
Mysql application.properties spring boot
SQL
4 votes128 views1 answer
Oracle table statistics last analyzed
SQL
4 votes139 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote141 views1 answer
Where name ends in SQL
SQL
-2 votes142 views2 answers
Sqlserver docker
SQL
0 vote134 views1 answer
How to output a different column name in mysql
SQL
2 votes136 views1 answer
Find all triggers in database
SQL
2 votes130 views1 answer
While loop sql
SQL

Share