Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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)