Home >Database >Mysql Tutorial >How to use the DAYOFMONTH function in MySQL
How to use the DAYOFMONTH function in MySQL
- WBOYforward
- 2023-05-26 10:22:20906browse
DAYOFMONTH(date)
SELECT DAYOFMONTH(‘2016-01-16') SELECT DAYOFMONTH(‘2016-01-16 00:00:00')
-> 16 (表示返回date是当月的第几天，1号就返回1，... ,31号就返回31)
The above is the detailed content of How to use the DAYOFMONTH 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
Previous article：How to query unique data in MySQLNext article：How to query unique data in MySQL