环境:HANA
目标:
select * from table
where
startdate <= 20230501 <=enddate
or startdate <= 20230502 <=enddate
or startdate <= 20230502 <=enddate
......
or startdate <= 20230513 <= enddate;
想要动态实现这个日期范围的选择应该怎么编写这个SQL?,求各位支支招,提供一下思路或者写个sql脚本?
或者HANA SQL 怎么实现获取两个日期之间的连续日期?脚本OR思路?
求