Day of week: Difference between revisions
Jump to navigation
Jump to search
(Created page with " {| class="wikitable sortable nowrap" |- ! style="text-align:right;" | Day ! Sunday ! Monday ! Tuesday ! Wednesday ! Thursday ! Friday ! Saturday |- ! Weekday ([https://dev.my...") |
No edit summary |
||
| Line 31: | Line 31: | ||
! This week | ! This week | ||
| SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY; | | SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY; | ||
| | | SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY; | ||
| | | SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY; | ||
| | | SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY; | ||
| | | SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY; | ||
| | | SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY; | ||
| | | SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY; | ||
|- | |- | ||
! Next week | ! Next week | ||
Revision as of 12:10, 21 August 2017
| 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; | SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY; | SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY; | SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY; | SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY; | SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY; | SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY; |
| Next week | SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; |
further reading
- PHP date function