I am trying to understand the both but I am getting really confused. Online it says:
MySQL WEEKDAY() returns the index of the day in a week for a given date (0 for Monday, 1 for Tuesday and ......6 for Sunday). MySQL DAYOFWEEK() returns the week day number (1 for Sunday,2 for Monday …… 7 for Saturday ) for a date specified as argument.
Can anyone explain with an example for both? Thank you.
解决方案
A relevant difference is that weekday counts the days of the week from Monday, as follows and start from 0
0=Monday, 1=Tuesday, 2=Wednesday, 3=Thursday, 4=Friday, 5=Saturday, 6=Sunday
On the other hand dayofweek counts the days of the week from Sunday and start with 1
1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday
Please try
select weekday(now()) weekday, dayofweek(now()) dayofweek;