/SQL/Mysql extract month from date

Mysql extract month from date

Mysql extract month

SELECT EXTRACT(MONTH FROM '2020-07-05')

2

Mysql extract month from date

SELECT MONTH(field_name) as month FROM yourtable

2

Mysql month name extract

SELECT MONTHNAME(column_date,’%m’)) as monthname from tablename;

1

Source: tutorialspoint.com

Similar codes

1 vote261 views2 answers
Sql split string by space
SQL
5 votes251 views1 answer
Oracle add time to date
SQL
0 vote231 views1 answer
Count number of entires by months sql
SQL
1 vote222 views1 answer
Sql server read uncommitted
SQL
0 vote235 views1 answer
Connect to nginx server mysql remotly
SQL
7 votes211 views1 answer
Query delete duplicates
SQL
5 votes232 views2 answers
Oracle apex debug mode
SQL
18 votes215 views3 answers
Mysql current date
SQL
6 votes224 views5 answers
Alter table oracle
SQL
0 vote221 views1 answer
Mysql_union
SQL

Share