oftoo的博客

知识关键词：DATE_FORMATselect DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks; select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tc_case group by

SELECT DATE_FORMAT(NOW(),'%y-%m-%d') - INTERVAL DAY(DATE_FORMAT(NOW(),'%y-%m-%d')) DAY AS '上个月最后一天', DATE_FORMAT(DATE_ADD(NOW(),INTERVAL -1 MONTH),'%y-%m-%d') - INTERVAL DAY(DATE_FORMAT(DATE_ADD...