常用SQL笔记MySQL
2025-04-08 23:58阅读:38评论:0
MySQL之查询本月的数据
1
2
3
4
5
6
7
SELECT * FROM tb_product WHERE create_date BETWEEN STR_TO_DATE( date_format( CURRENT_DATE (), '%Y-%m-01 00:00:00' ), '%Y-%m-%d %H:%i:%s' ) AND STR_TO_DATE( date_format( last_day( CURRENT_DATE ()), '%Y-%m-%d 23:59:59' ), '%Y-%m-%d %H:%i:%s' )