14,958
edits
Day of week: Difference between revisions
Jump to navigation
Jump to search
no edit summary
mNo edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Numeric representation of the day of the week. MySQL or | Numeric representation of the day of the week. MySQL, Excel or PHP approaches to specify these date time. | ||
== Weekday == | |||
{| class="wikitable sortable nowrap" | {| class="wikitable sortable nowrap" | ||
|- | |- | ||
| Line 48: | Line 49: | ||
| 6 | | 6 | ||
|- | |- | ||
|} | |||
== Get the date == | |||
{| class="wikitable sortable nowrap" | |||
|- | |||
! style="text-align:right;" | Day | |||
! Sunday | |||
! Monday | |||
! Tuesday | |||
! Wednesday | |||
! Thursday | |||
! Friday | |||
! Saturday | |||
|- | |||
! Last week | ! Last week | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())-6</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())-6</nowiki>}} | ||
| Line 55: | Line 72: | ||
| | | | ||
| | | | ||
| | | PHP: (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 64: | Line 81: | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+5</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+5</nowiki>}} | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+6</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+6</nowiki>}} | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+7</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+7</nowiki>}} <br />PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;</nowiki>}} | ||
|- | |- | ||
! Next week | ! Next week | ||