By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT DATE_FORMAT(NOW(), '%W');
| DATE_FORMAT(NOW(), '%W') |
|---|
| Wednesday |
SELECT DATE_FORMAT(NOW(), '%a');
| DATE_FORMAT(NOW(), '%a') |
|---|
| Wed |
| DATE_FORMAT(NOW(), '%W') |
|---|
| Wednesday |
| DATE_FORMAT(NOW(), '%a') |
|---|
| Wed |