14,958
edits
Day of week: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 49: | Line 49: | ||
|- | |- | ||
! Last week | ! Last week | ||
| SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())-6</nowiki>}} | ||
| | | | ||
| | | | ||
| Line 58: | Line 58: | ||
|- | |- | ||
! This week | ! This week | ||
| SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+1</nowiki>}} | ||
| SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+2</nowiki>}} | ||
| SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+3</nowiki>}} | ||
| SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+4</nowiki>}} | ||
| SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+5</nowiki>}} | ||
| SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+6</nowiki>}} | ||
| SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+7</nowiki>}} | ||
|- | |- | ||
! Next week | ! Next week | ||
| SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; | | MySQL: {{kbd | key=<nowiki>SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY;</nowiki>}} <br />Excel: {{kbd | key=<nowiki>=NOW()-WEEKDAY(NOW())+8</nowiki>}} | ||
| | | | ||
| | | | ||