/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 vote169 views1 answer
MySql Modify Increment
SQL
0 vote171 views1 answer
Copy value from one column to another postgres
SQL
7 votes159 views1 answer
Oracle reset sequence
SQL
0 vote208 views3 answers
Select top 10 rows in sql
SQL
1 vote179 views1 answer
Update foreign key value in mysql
SQL
0 vote176 views2 answers
Close external port 3306 with iptables
SQL
0 vote176 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote167 views1 answer
Sqlite referential integrity
SQL
37 votes284 views3 answers
Sql check duplicate value in column
SQL
2 votes179 views1 answer
Mysql last 7 days including today
SQL

Share