Day of week: Difference between revisions

Revision as of 17:04, 21 August 2017

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	MySQL: SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())-6
This week	MySQL: SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+1	MySQL: SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+2	MySQL: SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+3	MySQL: SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+4	MySQL: SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+5	MySQL: SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+6	MySQL: SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+7
Next week	MySQL: SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+8

further reading

@@ Line 82: / Line 82: @@
 * [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]
 * [https://stackoverflow.com/questions/23020162/how-to-get-this-coming-sundays-date mysql - How to get this coming Sunday's date? - Stack Overflow]
+* [https://support.microsoft.com/zh-tw/help/827327/how-to-return-a-day-of-the-week-for-a-date-in-excel 如何在 Excel 中傳回的日期星期幾]
 [[Category:PHP]]