/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

0 vote181 views1 answer
Sql check if column exists
SQL
-1 vote181 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote165 views1 answer
Sql with example
SQL
0 vote215 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
21 votes173 views1 answer
Cheatsheet for sql
SQL
0 vote164 views1 answer
RowDataPacket
SQL
16 votes193 views2 answers
Sql vs nosql
SQL
0 vote191 views1 answer
Postgres copy command
SQL
0 vote213 views1 answer
Stop and start mysql
SQL
0 vote206 views2 answers
Clauses in mysql
SQL

Share