Collections:
WEEKOFYEAR() - Calendar Week of Year
How to calculate the calendar week of year from a given date using the WEEKOFYEAR() function?
✍: FYIcenter.com
WEEKOFYEAR(date) is a MySQL built-in function that calculates the calendar week of year from a given date. For example:
SELECT WEEKOFYEAR('2024-03-04'), WEEK('2024-03-04', 3), WEEK('2024-03-04'); -- +--------------------------+-----------------------+--------------------+ -- | WEEKOFYEAR('2024-03-04') | WEEK('2024-03-04', 3) | WEEK('2024-03-04') | -- +--------------------------+-----------------------+--------------------+ -- | 10 | 10 | 9 | -- +--------------------------+-----------------------+--------------------+
Reference information of the WEEKOFYEAR() function:
WEEKOFYEAR(date): int Returns the calendar week of the date as a number in the range from 1 to 53. WEEKOFYEAR() is a compatibility function that is equivalent to WEEK(date,3). Arguments, return value and availability: date: Required. The date to extract the calendar week of year from. int: Return value. The calendar week of year. Available since MySQL 4.
Related MySQL functions:
⇐ WEEKDAY() - Weekday (0=Monday)
2023-11-17, 247🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...