Day of week
Jump to navigation
Jump to search
| Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|---|
| Weekday (MySQL) | 6 | 0 | 1 | 2 | 3 | 4 | 5 |
| Last week | SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY; | ||||||
| This week | SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY; | ||||||
| Next week | SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; |
further reading
- PHP date function