Day of week: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
No edit summary
Line 4: Line 4:
{| class="wikitable sortable nowrap"
{| class="wikitable sortable nowrap"
|-
|-
! style="text-align:right;" | Day
! style="text-align:right;" | Weekday values from different approaches
! Sunday
! Sunday
! Monday
! Monday
Line 13: Line 13:
! Saturday
! Saturday
|-
|-
! Weekday (ISO-8601 [http://php.net/manual/en/function.date.php PHP date] N character)
! [http://php.net/manual/en/function.date.php PHP date] with N format character: Weekday (ISO-8601)
| 7
| 7
| 1
| 1
Line 22: Line 22:
| 6
| 6
|-
|-
! Weekday ([https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday MySQL])
! ([https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday MySQL Weekday function])
| 6
| 6
| 0
| 0
Line 31: Line 31:
| 5
| 5
|-
|-
! Weekday ([https://support.office.com/zh-tw/article/WEEKDAY-%E5%87%BD%E6%95%B8-60e44483-2ed1-439f-8bd0-e404c190949a Excel])
! ([https://support.office.com/zh-tw/article/WEEKDAY-%E5%87%BD%E6%95%B8-60e44483-2ed1-439f-8bd0-e404c190949a Excel Weekday function])
| 1
| 1
| 2
| 2
Line 40: Line 40:
| 7
| 7
|-
|-
! Weekday ([http://php.net/manual/en/function.date.php PHP date] w character)
! [http://php.net/manual/en/function.date.php PHP date] with w format character
| 0
| 0
| 1
| 1
Line 50: Line 50:
|-
|-
|}
|}


== Get the date ==
== Get the date ==

Revision as of 14:02, 24 April 2018

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

Weekday

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

Get the date

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


References

  1. ↑ PHP: How to get previous Sunday of a specific date in the past..? - Stack Overflow

Further reading

Retrieved from "https://wiki.planetoid.info/index.php?title=Day_of_week&oldid=19385"