Day of week

From LemonWiki共筆
Revision as of 13:34, 21 August 2017 by Planetoid (talk | contribs)
Jump to navigation Jump to search

Numeric representation of the day of the week

Day Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Weekday (ISO-8601 PHP date N character) 7 1 2 3 4 5 6
Weekday (MySQL) 6 0 1 2 3 4 5
Weekday (Excel) 1 2 3 4 5 6 7
Weekday (PHP date w character) 0 1 2 3 4 5 6
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