15,032
edits
Day of week: Difference between revisions
Jump to navigation
Jump to search
→Weekday
m (→Get the date) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 43: | Line 43: | ||
| 7 | | 7 | ||
|- | |- | ||
! [https://support.office.com/zh-tw/article/WEEKDAY-%E5%87%BD%E6%95%B8-60e44483-2ed1-439f-8bd0-e404c190949a Excel WEEKDAY() function] | ! [https://support.office.com/zh-tw/article/WEEKDAY-%E5%87%BD%E6%95%B8-60e44483-2ed1-439f-8bd0-e404c190949a Excel WEEKDAY() function] e.g. WEEKDAY(A2) or WEEKDAY(A2, 1) | ||
| 1 | | 1 | ||
| 2 | | 2 | ||
| Line 51: | Line 51: | ||
| 6 | | 6 | ||
| 7 | | 7 | ||
|- | |||
! [https://support.office.com/zh-tw/article/WEEKDAY-%E5%87%BD%E6%95%B8-60e44483-2ed1-439f-8bd0-e404c190949a Excel WEEKDAY() function] e.g. WEEKDAY(A2, 2) | |||
| 7 | |||
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
|- | |- | ||
! [http://php.net/manual/en/function.date.php PHP date] with w format character | ! [http://php.net/manual/en/function.date.php PHP date] with w format character | ||
| Line 86: | Line 95: | ||
| | | | ||
| | | | ||
| PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime('Friday -7 day')) . PHP_EOL;</nowiki>}} | | MySQL: {{kbd | key=SELECT CURDATE() + INTERVAL <span class="hightlight">-3</span> - WEEKDAY(CURDATE()) DAY;}} <br />PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime('Friday -7 day')) . PHP_EOL;</nowiki>}} | ||
| MySQL: {{kbd | key=SELECT CURDATE() + INTERVAL <span class="hightlight">-2</span> - WEEKDAY(CURDATE()) DAY;}} <br /> PHP<ref>[https://stackoverflow.com/questions/3742820/php-how-to-get-previous-sunday-of-a-specific-date-in-the-past PHP: How to get previous Sunday of a specific date in the past..? - Stack Overflow]</ref>: (1) {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("last Saturday")) . PHP_EOL;</nowiki>}} (2) {{kbd | key=<nowiki>echo date('Y-m-d', strtotime('last Saturday', strtotime("2018-03-04 00:01:00"))) . PHP_EOL;</nowiki>}} | | MySQL: {{kbd | key=SELECT CURDATE() + INTERVAL <span class="hightlight">-2</span> - WEEKDAY(CURDATE()) DAY;}} <br /> PHP<ref>[https://stackoverflow.com/questions/3742820/php-how-to-get-previous-sunday-of-a-specific-date-in-the-past PHP: How to get previous Sunday of a specific date in the past..? - Stack Overflow]</ref>: (1) {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("last Saturday")) . PHP_EOL;</nowiki>}} (2) {{kbd | key=<nowiki>echo date('Y-m-d', strtotime('last Saturday', strtotime("2018-03-04 00:01:00"))) . PHP_EOL;</nowiki>}} | ||
|- | |- | ||
| Line 118: | Line 127: | ||
* [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia] | * [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://stackoverflow.com/questions/23020162/how-to-get-this-coming-sundays-date mysql - How to get this coming Sunday's date? - Stack Overflow] | ||
* [https://support.office.com/zh-tw/article/today-%E5%87%BD%E6%95%B8-5eb3078d-a82c-4736-8930-2f51a028fdd9 TODAY 函數 - Office 支援] | * [https://support.office.com/zh-tw/article/today-%E5%87%BD%E6%95%B8-5eb3078d-a82c-4736-8930-2f51a028fdd9 TODAY 函數 - Office 支援] | ||
* [https://errerrors.blogspot.com/2026/06/spreadsheet-weekday-formula.html 在 Google 試算表、Excel 與 LibreOffice Calc 如何顯示星期幾] | |||
[[Category:PHP]] | [[Category:PHP]] | ||