Question

How does DAYOFMONTH (), DAYOFWEEK() and DAYOFYEAR( ) work?

Answer 1

The DAYOFMONTH() function returns a value between 1 and 31 (or 0 for dates with a zero day part) that represents the day of the month. It resets back to 1 at the start of each month. The DAYOFWEEK() function on the other hand, returns a value between 1 and 7. It resets back to 1 at the start of each week.