dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Jul 31, 2019

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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) |
+---------------------------+
M S Sridhar
 
Thanks for your registration, follow us on our social networks to keep up-to-date