随笔分类 -  SQL

当天，本周，本月
摘要：当天 TO_DAYS(createTime) = TO_DAYS(NOW()) 本周 YEARWEEK(DATE_FORMAT(createTime,'%Y-%m-%d'),1) = YEARWEEK(NOW(),7) 本月 DATE_FORMAT(createTime,'%Y-%m') = DAT 阅读全文
posted @ 2022-06-07 20:33 形码客 阅读(32) 评论(0) 推荐(0)