Day of week - Revision history

Planetoid: /* Get the date */

2019-05-13T10:47:10Z

Get the date

← Older revision		Revision as of 18:47, 13 May 2019
Line 86:		Line 86:
	\|		\|
	\|		\|
	\| 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>}}
	\|-		\|-

Planetoid: /* Get the date */

2019-05-13T10:42:58Z

Get the date

← Older revision		Revision as of 18:42, 13 May 2019
Line 86:		Line 86:
	\|		\|
	\|		\|
	\|		\| 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 95:		Line 95:
	\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">2</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+4</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">2</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+4</nowiki>}}
	\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">3</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+5</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">3</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+5</nowiki>}}
	\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">4</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+6</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">4</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+6</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime('Friday')) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">5</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">5</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}}
	\|-		\|-
Line 104:		Line 104:
	\|		\|
	\|		\|
	\|		\| PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime('Friday +7 day')) . PHP_EOL;</nowiki>}}
	\|		\|
	\|-		\|-

Planetoid: /* Get the date */

2019-01-02T09:07:52Z

Get the date

← Older revision		Revision as of 17:07, 2 January 2019
Line 81:		Line 81:

	! Last week		! Last week
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())-6</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday -14 day")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">-8</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())-6</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday -14 day")) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL -7 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())-5</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week -7 day")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">-7</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())-5</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week -7 day")) . PHP_EOL;</nowiki>}}
	\|		\|
	\|		\|
	\|		\|
	\|		\|
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() - ~~INTERVAL~~ 2 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <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>}}
	\|-		\|-
	! This week		! This week
Line 99:		Line 99:
	\|-		\|-
	! Next week		! Next week
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+8</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">6</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+8</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday")) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 7 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+9</nowiki>}}<br />PHP: (1) {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("next monday")) . PHP_EOL;</nowiki>}} (2) {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week +7 day")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">7</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+9</nowiki>}}<br />PHP: (1) {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("next monday")) . PHP_EOL;</nowiki>}} (2) {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week +7 day")) . PHP_EOL;</nowiki>}}
	\|		\|
	\|		\|

Planetoid: /* Weekday */ modify the order

2018-12-24T08:19:07Z

Weekday: modify the order

← Older revision		Revision as of 16:19, 24 December 2018
Line 25:		Line 25:
	\| 6		\| 6
	\|-		\|-
	! [https://~~www~~.~~w3schools~~.com/~~sql~~/~~func_mysql_dayofweek~~.~~asp~~ MySQL ~~DAYOFWEEK~~() ~~Function~~]		! [https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday MySQL WEEKDAY() function]
			\| 6
			\| 0
	\| 1		\| 1
	\| 2		\| 2
Line 31:		Line 33:
	\| 4		\| 4
	\| 5		\| 5
	~~\| 6~~
	~~\| 7~~
	\|-		\|-
	! [https://~~dev~~.~~mysql~~.com/~~doc~~/~~refman/5.5/en/date-and-time-functions~~.~~html#function_weekday~~ MySQL ~~WEEKDAY~~() ~~function~~]		! [https://www.w3schools.com/sql/func_mysql_dayofweek.asp MySQL DAYOFWEEK() Function]
	~~\| 6~~
	~~\| 0~~
	\| 1		\| 1
	\| 2		\| 2
Line 42:		Line 40:
	\| 4		\| 4
	\| 5		\| 5
			\| 6
			\| 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]

Planetoid: /* Weekday */ + MySQL DAYOFWEEK() Function https://www.w3schools.com/sql/func_mysql_dayofweek.asp

2018-12-24T08:14:03Z

Weekday: + MySQL DAYOFWEEK() Function https://www.w3schools.com/sql/func_mysql_dayofweek.asp

← Older revision		Revision as of 16:14, 24 December 2018
Line 24:		Line 24:
	\| 5		\| 5
	\| 6		\| 6
			\|-
			! [https://www.w3schools.com/sql/func_mysql_dayofweek.asp MySQL DAYOFWEEK() Function]
			\| 1
			\| 2
			\| 3
			\| 4
			\| 5
			\| 6
			\| 7
	\|-		\|-
	! [https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday MySQL WEEKDAY() function]		! [https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday MySQL WEEKDAY() function]

Planetoid: /* Get the date */

2018-12-18T03:05:40Z

Get the date

← Older revision		Revision as of 11:05, 18 December 2018
Line 81:		Line 81:
	\|-		\|-
	! This week		! This week
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+1</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday -7 day")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">-1</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+1</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday -7 day")) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+2</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">0</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+2</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week")) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+3</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">1</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+3</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+4</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">2</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+4</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+5</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">3</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+5</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+6</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">4</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+6</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">5</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}}
	\|-		\|-
	! Next week		! Next week

Planetoid: /* Get the date */

2018-12-17T07:27:39Z

Get the date

← Older revision		Revision as of 15:27, 17 December 2018
Line 56:		Line 56:

	== Get the date ==		== Get the date ==
			Get the date of weekday from another known date (today or another specific day)

	<div style="width:100%; min-height: .01%; overflow-x: auto;">		<div style="width:100%; min-height: .01%; overflow-x: auto;">
	{\| class="wikitable sortable nowrap"		{\| class="wikitable sortable nowrap"

Planetoid: /* Weekday */

2018-12-17T03:57:10Z

Weekday

← Older revision		Revision as of 11:57, 17 December 2018
Line 2:		Line 2:

	== Weekday ==		== Weekday ==
			The value of weekday obtained from different approaches.

	<div style="width:100%; min-height: .01%; overflow-x: auto;">		<div style="width:100%; min-height: .01%; overflow-x: auto;">
	{\| class="wikitable sortable nowrap"		{\| class="wikitable sortable nowrap"

Planetoid at 07:45, 19 November 2018

2018-11-19T07:45:52Z

← Older revision		Revision as of 15:45, 19 November 2018
Line 2:		Line 2:

	== Weekday ==		== Weekday ==
			<div style="width:100%; min-height: .01%; overflow-x: auto;">
	{\| class="wikitable sortable nowrap"		{\| class="wikitable sortable nowrap"
	\|-		\|-
Line 50:		Line 51:
	\|-		\|-
	\|}		\|}
			</div>

	== Get the date ==		== Get the date ==
			<div style="width:100%; min-height: .01%; overflow-x: auto;">
	{\| class="wikitable sortable nowrap"		{\| class="wikitable sortable nowrap"
	\|-		\|-
Line 92:		Line 95:
	\|-		\|-
	\|}		\|}
			</div>

	== References ==		== References ==

Planetoid: /* Weekday */

2018-11-19T07:44:51Z

Weekday

← Older revision		Revision as of 15:44, 19 November 2018
Line 22:		Line 22:
	\| 6		\| 6
	\|-		\|-
	! [https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_weekday MySQL ~~Weekday~~ function]		! [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
	\|-		\|-
	! [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]
	\| 1		\| 1
	\| 2		\| 2

← Older revision		Revision as of 11:05, 18 December 2018
Line 81:		Line 81:
	\|-		\|-
	! This week		! This week
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+1</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday -7 day")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">-1</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+1</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Sunday -7 day")) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+2</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">0</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+2</nowiki>}}<br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("monday this week")) . PHP_EOL;</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+3</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">1</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+3</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+4</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">2</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+4</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+5</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">3</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+5</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+6</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">4</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+6</nowiki>}}
	\| MySQL: {{kbd \| key=~~<nowiki>~~SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY;~~</nowiki>~~}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}}		\| MySQL: {{kbd \| key=SELECT CURDATE() + INTERVAL <span class="hightlight">5</span> - WEEKDAY(CURDATE()) DAY;}} <br />Excel: {{kbd \| key=<nowiki>=TODAY()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd \| key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}}
	\|-		\|-
	! Next week		! Next week