17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> select systimestamp, systimestamp+numtodsinterval(1/24, 'DAY') from dual;
SYSTIMESTAMP SYSTIMESTAMP+NUMTODSINTERVAL(1
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
16-6月 -11 09.57.45.989000 上午 +08:00 16-6月 -11 10.57.45.989000000 上午 +08:00
SQL>
SELECT *
FROM QB_ORACLE
WHERE DTRQ BETWEEN systimestamp - 30 / 1440 AND systimestamp;