/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 vote157 views4 answers
What is unique key in sql
SQL
0 vote152 views1 answer
Mysql pad zeros
SQL
0 vote142 views4 answers
First max salary in sql
SQL
0 vote148 views1 answer
Java sql connection
SQL
0 vote171 views1 answer
Codigo crear tablas sql server
SQL
8 votes156 views3 answers
SQL column name
SQL
0 vote141 views1 answer
Mysql case when null
SQL
0 vote140 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
5 votes142 views1 answer
Minecraft java port number
SQL
1 vote147 views1 answer
Setval pgsql
SQL

Share