求大神解惑,如何获取我选择年份的每月的某一天
sqlserver例子:
select * from 表 where year(日期)='${year(参数)}' and day(日期)='${day(参数)}'
------------------------------
=MAPARRAY(GREPARRAY(range(date("2021","01","01"),date("2021","12","31")),day(item)=21),format(item,"yyyy-MM-dd"))
用SUBSTRING截取日期字段把日截取出来,等于你需要的天