/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 vote147 views1 answer
Where database run
SQL
0 vote181 views1 answer
Install postgresql 12 on debian 10
SQL
3 votes95 views1 answer
How to get list of synonyms in oracle
SQL
1 vote142 views1 answer
Mysql count words
SQL
0 vote147 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote155 views1 answer
Float precision in psql
SQL
0 vote146 views1 answer
Not equal to blank in mysql
SQL
0 vote161 views1 answer
Sintaxis SELECT sql
SQL
0 vote160 views2 answers
Collation in sql
SQL
0 vote140 views1 answer
Codeigniter 3 get best-selling products
SQL

Share