/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 vote215 views2 answers
Clauses in mysql
SQL
0 vote199 views1 answer
Codigo crear tablas sql server
SQL
0 vote199 views1 answer
Postgres statistics
SQL
0 vote214 views2 answers
Mysql where in maintain order group_concat
SQL
1 vote199 views1 answer
How to select multiple columns from different tables in mysql
SQL
4 votes193 views3 answers
Oracle sql first day of quarter
SQL
0 vote190 views1 answer
Mysql select where field is a value
SQL
22 votes205 views3 answers
SQL CHEATSHEET
SQL
-1 vote194 views1 answer
Mac mysql workbench console
SQL
0 vote212 views2 answers
Check if sql temp table exists
SQL

Share