Mega Code Archive

 

Categories / MySQL / Date Time

 

Table shows the DAYOFWEEK( ) expressions to use for putting any day of the week first in the sort order

Day to list first                 DAYOFWEEK( ) expression Sunday                            DAYOFWEEK(date) Monday                            MOD(DAYOFWEEK(date) + 5, 7) Tuesday                           MOD(DAYOFWEEK(date) + 4, 7) Wednesday                         MOD(DAYOFWEEK(date) + 3, 7) Thursday                          MOD(DAYOFWEEK(date) + 2, 7) Friday                            MOD(DAYOFWEEK(date) + 1, 7) Saturday                          MOD(DAYOFWEEK(date) + 0, 7)