Day of week

From LemonWiki共筆
Revision as of 12:10, 21 August 2017 by Planetoid (talk | contribs)
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; 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