/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 vote138 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
7 votes163 views1 answer
Alter sequence set current value oracle
SQL
0 vote153 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote159 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
12 votes227 views4 answers
How to drop all tables in postgresql
SQL
0 vote131 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote196 views1 answer
Selecting specific day in colum sql
SQL
2 votes141 views2 answers
Mysql user access to database
SQL
11 votes148 views2 answers
Having in sql
SQL
35 votes158 views6 answers
Postgres
SQL

Share