mysql dayofweek()_Mysql WEEKDAY（）与Mysql DayofWeek（）

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;