0919MYSQL take the first and last day of the current week/month/quarter/year

http://blog.csdn.net/cleanfield/article/details/41447585

Compiled SQL code, all executable

2. #当年第一天:
4. SELECT date_sub (Curdate (), INTERVAL DayOfYear (Now ()) – 1 day );
8. #当年最后一天:
10. SELECT concat (now()),'-12-31 ');
14. #当前week的第一天:
16. Select Date_sub (Curdate (), INTERVAL WEEKDAY (Curdate ()) + 1 day );
20. #当前week的最后一天:
22. Select Date_sub (Curdate (), INTERVAL WEEKDAY (Curdate ())-5 day );
26. #前一week的第一天:
28. Select Date_sub (Curdate (), INTERVAL WEEKDAY (Curdate ()) + 8 day );
32. #前一week的最后一天:
34. Select Date_sub (Curdate (), INTERVAL WEEKDAY (Curdate ()) + 2 day );
38. #前两week的第一天:
40. Select Date_sub (Curdate (), INTERVAL WEEKDAY (Curdate ()) + day );
44. #前两week的最后一天:
46. Select Date_sub (Curdate (), INTERVAL WEEKDAY (Curdate ()) + 9 day );
50. #当前The first day of month:
52. SELECT concat (Date_format (Last_day (now ()),'%y-%m-'),' 01 ');
56. #当前The last day of month:
58. SELECT Last_day (now ());
62. #前一The first day of month:
64. SELECT concat (Date_format (Last_day (now ()-Interval 1 month), '%y-%m-'),' 01 ');
68. #前一The last day of month:
70. SELECT Last_day (now ()-Interval 1 month);
74. #前两The first day of month:
76. SELECT concat (Date_format (Last_day (now ()-Interval 2 month), '%y-%m-'),' 01 ');
80. #前两The last day of month:
82. SELECT Last_day (now ()-Interval 2 month);
86. #当前quarter的第一天:
88. Select Concat (Date_format (Last_day (Makedate (EXTRACT (year from curdate ()), 1) + Interval QUARTER (curdate ()) *   3-3 month), '%y-%m-'),' 01 ');
92. #当前quarter的最后一天:
94. Select Last_day (Makedate (EXTRACT (year from curdate ()), 1) + Interval QUARTER (curdate ()) *3-1 month);
98. #前一quarter的第一天:
100. Select Concat (Date_format (Last_day (Makedate (EXTRACT (year from curdate ()), 1) + Interval QUARTER (curdate ()) *  3-6 month), '%y-%m-'),' 01 ');
104. #前一quarter的最后一天:
106. Select Last_day (Makedate (EXTRACT (year from curdate ()), 1) + Interval QUARTER (curdate ()) *3-4 month);
110. #前两quarter的第一天:
112. Select Concat (Date_format (Last_day (Makedate (EXTRACT (year from curdate ()), 1) + Interval QUARTER (curdate ()) *  3-9 month), '%y-%m-'),' 01 ');
116. #前两quarter的最后一天:
118. Select Last_day (Makedate (EXTRACT (year from curdate ()), 1) + Interval QUARTER (curdate ()) *3-7 month);

0919MYSQL take the first and last day of the current week/month/quarter/year