MySQL Count Weekday Occurrences
Digital Owl’s Prose
Published in
7 min readApr 7, 2021
Each SQL dialect is different in some way, shape, form, or fashion from the next flavor. Some dialects have this function, while others have that function. In this post, I cover porting over Oracle SQL to MySQL in order to count the number of occurrences of a specific weekday found in the current given month (at the time of writing) purely as a learning exercise focused on MySQL DATE
functions and the WITH
clause…