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


advertisement
 

Tip: Using the WEEKOFYEAR Function in MySQL

Learn how to use calendar functionality in MySQL to figure out in which week a given date belongs.


advertisement

WEBINAR:

On-Demand

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


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) |
+---------------------------+

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Thanks for your registration, follow us on our social networks to keep up-to-date