Day of week: Difference between revisions

Revision as of 14:12, 25 April 2018

Numeric representation of the day of the week. MySQL, Excel or PHP approaches to specify these date time.

Weekday values from different approaches	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
PHP date with N format character: Weekday (ISO-8601)	7	1	2	3	4	5	6
MySQL Weekday function	6	0	1	2	3	4	5
Excel Weekday function	1	2	3	4	5	6	7
PHP date with w format character	0	1	2	3	4	5	6

Day	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Last week	MySQL: SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())-6						PHP^[1]: (1) echo date('Y-m-d', strtotime("last Saturday")) . PHP_EOL; (2) echo date('Y-m-d', strtotime('last Saturday', strtotime("2018-03-04 00:01:00"))) . PHP_EOL;
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 PHP: echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;
Next week	MySQL: SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+8

@@ Line 13: / Line 13: @@
 ! Saturday
 |-
-! [http://php.net/manual/en/function.date.php PHP date] with N format character: Weekday (ISO-8601)
+! [http://php.net/manual/en/function.date.php PHP date] with N format character: Weekday ([https://en.wikipedia.org/wiki/ISO_week_date ISO-8601])
 | 7
 | 1