Home  >  Article  >  Database  >  How to use the MONTHNAME function in MySQL

How to use the MONTHNAME function in MySQL

WBOY
WBOYforward
2023-05-31 21:46:041289browse

MONTHNAME(date)

SELECT MONTHNAME(‘2016-01-16') 
SELECT MONTHNAME(‘2016-01-16 00:00:00')
-> January (表示返回date的是当年第几月的英文名字)

The above is the detailed content of How to use the MONTHNAME function in MySQL. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:yisu.com. If there is any infringement, please contact admin@php.cn delete