weixin_43034862的博客

获取本月时间– 本月SELECT DATE_FORMAT( CURDATE(), ‘%Y-%m-01 00:00:00’) AS ‘本月初’;SELECT DATE_FORMAT( LAST_DAY(CURDATE()), ‘%Y-%m-%d 23:59:59’) AS ‘本月末’;8、查询本月的记录SELECT * FROM 表名 WHERE DATE_FORMAT( 时间字段名, ‘...