Mysql date query list

First day of the current week:

Select date_sub (curdate (), INTERVAL WEEKDAY (curdate ()) + 1 DAY)

Last day of the current week:

Select date_sub (curdate (), INTERVAL WEEKDAY (curdate ())-5 DAY)

The first day of the previous week:

Select date_sub (curdate (), INTERVAL WEEKDAY (curdate ()) + 8 DAY)

The last day of the previous week:

Select date_sub (curdate (), INTERVAL WEEKDAY (curdate ()) + 2 DAY)

The first day of the first two week:

Select date_sub (curdate (), INTERVAL WEEKDAY (curdate ()) + 15 DAY)

The last day of the first two week:

Select date_sub (curdate (), INTERVAL WEEKDAY (curdate ()) + 9 DAY)

First day of the current month:

SELECT concat (date_format (LAST_DAY (now ()),'% Ymuri% mmuri'), '01')

Last day of the current month:

SELECT LAST_DAY (now ())

The first day of the previous month:

SELECT concat (date_format (LAST_DAY (now ()-interval 1 month),'% Ymuri% MMI'), '01')

The last day of the previous month:

SELECT LAST_DAY (now ()-interval 1 month)

The first day of the first two month:

SELECT concat (date_format (LAST_DAY (now ()-interval 2 month),'% Ymuri% MMI'), '01')

The last day of the first two month:

SELECT LAST_DAY (now ()-interval 2 month)

First day of the current quarter:

Select concat (date_format (LAST_DAY (MAKEDATE (EXTRACT (YEAR FROM CURDATE ()), 1) + interval QUARTER (CURDATE ()) * 3-3 month),'% Ymuri% Mmuri'), '01')

Last day of the current quarter:

Select LAST_DAY (MAKEDATE (EXTRACT (YEAR FROM CURDATE ()), 1) + interval QUARTER (CURDATE ()) * 3-1 month)

The first day of the previous week:

Select concat (date_format (LAST_DAY (MAKEDATE (EXTRACT (YEAR FROM CURDATE ()), 1) + interval QUARTER (CURDATE ()) * 3-6 month),'% Ymuri% Mmuri'), '01')

The last day of the previous week:

Select LAST_DAY (MAKEDATE (EXTRACT (YEAR FROM CURDATE ()), 1) + interval QUARTER (CURDATE ()) * 3-4 month)

The first day of the first two quarter:

Select concat (date_format (LAST_DAY (MAKEDATE (EXTRACT (YEAR FROM CURDATE ()), 1) + interval QUARTER (CURDATE ()) * 3-9 month),'% Ymuri% Mmuri'), '01')

The last day of the first two quarter:

Select LAST_DAY (MAKEDATE (EXTRACT (YEAR FROM CURDATE ()), 1) + interval QUARTER (CURDATE ()) * 3-7 month)