Home >Database >Mysql Tutorial >How to use the DAYOFYEAR function in MySQL
How to use the DAYOFYEAR function in MySQL
- PHPzforward
- 2023-05-31 19:52:111542browse
DAYOFYEAR(date)
SELECT DAYOFYEAR(‘2016-03-31') SELECT DAYOFYEAR(‘2016-03-31 00:00:00')
-> 91 (表示返回date是当年的第几天，01.01返回1，... ,12.31就返回365)
The above is the detailed content of How to use the DAYOFYEAR 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：What is the method to view the table structure in mysqlNext article：What is the method to view the table structure in mysql