and to_days(time) = to_days(CURDATE())
本周(从周天开始算起)
and WEEK(time) = WEEK(CURDATE()) // 从周天开始算起
and WEEK(time, 1) = WEEK(CURDATE(), 1) // 从周一开始算起
本月
and MONTH( time ) = MONTH(CURDATE())
and to_days(time) = to_days(CURDATE())
本周(从周天开始算起)
and WEEK(time) = WEEK(CURDATE()) // 从周天开始算起
and WEEK(time, 1) = WEEK(CURDATE(), 1) // 从周一开始算起
本月
and MONTH( time ) = MONTH(CURDATE())