MariaDB YEARWEEK() Function
The MariaDB YEARWEEK() function returns the year value as well as the week value of a given date or datetime value.
The returned year value can be different from year displayed in the datetime because of the mode specified. This happens in the first and last week of the year. Similarly, the week value can be between 0-53 or 1-53 depending on the specified mode.
mode and description
|0||First day of the week is Sunday||0-53|
|1||First day of the week is Monday and the first week has more than 3 days||0-53|
|2||First day of the week is Sunday||1-53|
|3||First day of the week is Monday and the first week has more than 3 days||1-53|
|4||First day of the week is Sunday and the first week has more than 3 days||0-53|
|5||First day of the week is Monday||0-53|
|6||First day of the week is Sunday and the first week has more than 3 days||1-53|
|7||First day of the week is Monday||1-53|
Returns the year and week for a given date or datetime value.
The example below shows the usage of YEARWEEK() function.
SELECT YEARWEEK('2018-08-18'); Result: 201832 SELECT YEARWEEK('2018-08-18 10:38:42'); Result: 201832 SELECT YEARWEEK('2018-08-18 10:38:42.000004'); Result: 201832 SELECT YEARWEEK('2014-10-20'); Result: 201442 SELECT YEARWEEK(CURDATE()); Result: 202148
Consider a database table called Orders with the following records:
The query given below can be used to get the the year and week for records of column OrderTime:
SELECT *, YEARWEEK(OrderTime, 5) AS YEARWEEK_Value FROM Orders;
This will produce the result as shown below:
❮ MariaDB Functions