SELECT * FROM TBL_PROB_CELL_STATS t WHERE t.STATS_TIME BETWEEN (SELECT Trunc((add_months(SYSDATE, -2)) ,'MONTH') FROM dual) AND (SELECT LAST_DAY(Trunc(SYSDATE, 'MONTH')) + 1 - 1 / 86400 Last_Day_Cur_Month
FROM dual);
Oracle:查询数据库某行的数据(date类型)在三个月内
最新推荐文章于 2023-08-01 15:51:10 发布