How to get the number of weekend days in mysql?

Question

I want to count the number of saturdays and sundays in a certain year. Is there any way that I can do that in sql?

What does this have to do with sql? – Strawberry Aug 01 '18 at 04:43 — Strawberry, Aug 01 '18 at 04:43

score 0 · Answer 1 · answered Aug 01 '18 at 03:34

0

As alternative solution you could have a look at the answer in this post right here. It shows how to calculate the weekdays between to dates and can be easily adjusted to calculate Saturdays/Sundays.

answered Aug 01 '18 at 03:34

C. Raffick

30
6

How to get the number of weekend days in mysql?

1 Answers1