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

    xiaoxiao2022-07-12  125

     SQL如下:

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

    效果如下,

    最新回复(0)