14,958
edits
Day of week: Difference between revisions
Jump to navigation
Jump to search
→Get the date
m (→Weekday) |
|||
| Line 65: | Line 65: | ||
! 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>}}<br />PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("Sunday -14 day")) . PHP_EOL;</nowiki>}} | ||
| | | PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("monday this week -7 day")) . PHP_EOL;</nowiki>}} | ||
| | | | ||
| | | | ||
| Line 74: | Line 74: | ||
|- | |- | ||
! This week | ! This week | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+1</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-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>=NOW()-WEEKDAY(NOW())+2</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-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>=NOW()-WEEKDAY(NOW())+3</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+3</nowiki>}} | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+4</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+4</nowiki>}} | ||
| Line 83: | Line 83: | ||
|- | |- | ||
! Next week | ! Next week | ||
| MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+8</nowiki>}} | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+8</nowiki>}}<br />PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("Sunday")) . PHP_EOL;</nowiki>}} | ||
| | | PHP: {{kbd | key=<nowiki>echo date('Y-m-d', strtotime("monday this week +7 day")) . PHP_EOL;</nowiki>}} | ||
| | | | ||
| | | | ||
| Line 92: | Line 92: | ||
|- | |- | ||
|} | |} | ||
== References == | == References == | ||