数据库联合查询具体时间

如图是我今天刚刚录入的信息，若此表中有一年的信息，我如何能筛选出当中一月份的信息呢（加上我图示的查询条件）

year(date)=2022 and month(date)=1

post_date>='2022-01-01 00:00:00' and post_date < '2022-02-01 00:00:00'

select * from table where year(date)=2022 and month(date)=1

where year(date)=2022 and month(date)=1