Using the WEEKOFYEAR Function in MySQL

MySQL has abundant functions that support a multitude of application needs. Here, we shall use some Calendar functionality to find in which week a given date belongs.

Samples:

Considering the date, 28th February of 2000, the following syntax in MySQL will result as below

Query 1:

SELECT WEEKOFYEAR("2000-02-28")

Output:

+---------------------------+| WEEKOFYEAR("2000-02-28")  |+---------------------------+|                         9 |+---------------------------+

This implies that the date is part of week 9 in the calendar year 2000.

Query 2: Similarly, we shall look at 29th February of 2000 and since the year is a leap year, this date is valid. The below is the result.

SELECT WEEKOFYEAR("2000-02-29")

Output:

+---------------------------+| WEEKOFYEAR("2000-02-29")  |+---------------------------+|                         9 |+---------------------------+

Query 3: We can look at 29th February of 2001, which is NOT a valid date since this is NOT a leap year. The code below is the result.

SELECT WEEKOFYEAR("2001-02-29")

Output:

+---------------------------+| WEEKOFYEAR("2001-02-29")  |+---------------------------+|                    (NULL) |+---------------------------+
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts