-- 方式一:year和month函数
select
day(create_time), id, name
from
product
where
year(create_time) = 2020 and month(create_time) = 2;
-- 方式二:date_format函数
select
day(create_time), id, name
from
product
where date_format(create_time, "%Y-%m")="202002";
MySQL查询某年或者某月的数据
最新推荐文章于 2024-05-29 16:05:24 发布