Setting the default start of the week in MySQL

[rocketman]

If you are a) using MySQL and b) wish to change the start of the week from Sunday to Monday (affects the WEEK(date) function.

Type this at the MySQL command line prompt

mysql> set GLOBAL default_week_format=1;