MySQL当月第一天

导语

部分实用的日期函数组合查询。

查询：本周，本月，本季度，本年的第一天和最后一天#查询本周第一天ｓｅｌｅｃｔ DATE_SUB(CURDATE(),INTERVAL WEEKDAY(CURDATE()) DAY) AS TIME;#查询本周的最后一天ｓｅｌｅｃｔ DATE_SUB(CURDATE(),INTERVAL WEEKDAY(CURDATE())-6 DAY) AS TIME;#查询本月的第一天ｓｅｌｅｃｔ DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY) AS TIME;#查询本月的最后一天ｓｅｌｅｃｔ LAST_DAY(CURDATE()) AS TIME;#当前quarter的第一天：ｓｅｌｅｃｔ ｃｏｎｃａｔ(date_format(LAST_DAY(MAKEDATE(EXTRACT(YEAR FROMCURDATE()),1) + interval QUARTER(CURDATE())*3-3 month),‘%Y-%m-‘),‘01‘); #当前quarter的最后一天：ｓｅｌｅｃｔ LAST_DAY(MAKEDATE(EXTRACT(YEARFROM CURDATE()),1) + interval QUARTER(CURDATE())*3-1 month);#当年第一天：ｓｅｌｅｃｔ DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY); #当年最后一天：ｓｅｌｅｃｔ ｃｏｎｃａｔ(YEAR(now()),‘-12-31‘);