Home  >  Article  >  Database  >  How to use WEEKOFYEAR function in MySQL

How to use WEEKOFYEAR function in MySQL

王林
王林forward
2023-06-03 17:08:431561browse

WEEKOFYEAR(date): Get the week of the year that the day is

SELECT WEEKOFYEAR(SYSDATE()) 
SELECT WEEKOFYEAR(‘2015-01-10')
-> 2
-> 2

The above is the detailed content of How to use WEEKOFYEAR 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