DB2获取指定某天到昨天的日期

 SQL如下：

SELECT CURRENT_DATE - ((ROW_NUMBER() OVER (ORDER BY 1))) DAY AS YESTERDAY FROM SYSIBM.SYSCOLUMNS FETCH FIRST 10 ROWS ONLY;

效果如下，