mysql get week number from date code example
Example 1: mysql get day of week
DAYOFWEEK();//(1 for Sunday,2 for Monday …… 7 for Saturday )
Example 2: mysql date of the week
DAYOFWEEK(date)
DAYOFWEEK();//(1 for Sunday,2 for Monday …… 7 for Saturday )
DAYOFWEEK(date)