How does DAYOFMONTH (), DAYOFWEEK() and DAYOFYEAR( ) work?
Answers
Answered by
0
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.
Similar questions