DECLARE
W_基准日 DATE;
BEGIN
SELECT CASE WHEN TO_CHAR(SYSDATE,'hh24')>'21' THEN SYSDATE + 1 ELSE SYSDATE END CASE INTO W_基准日 FROM dual;
DBMS_OUTPUT.PUT_LINE(TO_CHAR(W_基准日));
END;
--
14-12月-06
W_基准日 DATE;
BEGIN
SELECT CASE WHEN TO_CHAR(SYSDATE,'hh24')>'21' THEN SYSDATE + 1 ELSE SYSDATE END CASE INTO W_基准日 FROM dual;
DBMS_OUTPUT.PUT_LINE(TO_CHAR(W_基准日));
END;
--
14-12月-06
select trunc(sysdate + INTERVAL '3' HOUR) from dual;
or:
select trunc(sysdate + NUMTODSINTERVAL(3, 'HOUR') ) from dual;