/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 vote263 views1 answer
Is sql fast
SQL
7 votes198 views4 answers
Lowest salary in sql
SQL
4 votes209 views2 answers
Postgre sql create table
SQL
0 vote196 views5 answers
Linq cheat sheet
SQL
0 vote166 views2 answers
Avg() sql
SQL
2 votes194 views1 answer
Can you use a where clause for a child query
SQL
3 votes161 views4 answers
Mysql delete duplicate rows
SQL
1 vote225 views1 answer
Mysql update inner
SQL
0 vote201 views1 answer
Sql create table with datetime automatically
SQL
0 vote230 views3 answers
Condition in count sql
SQL

Share