How to check Day of week?
Something is wrong here.
I need help.
-- Abfragezeitpunkt bestimmen
SET TERM ON;
SELECT TO_CHAR(SYSDATE - 1,'DD.MM.YYYY') vondatum,
TO_CHAR(SYSDATE,'DD.MM.YYYY') bisdatum
FROM DUAL;
VARIABLE POSTING_DATE VARCHAR2(10);
VARIABLE DELIVER_DATE VARCHAR2(10);
BEGIN
:POSTING_DATE := '&VONDATUM';
:DELIVER_DATE := '&BISDATUM';
IF TO_CHAR(:POSTING_DATE,'D') = 5 --if day of week friday then change value of deliver_date
THEN
:DELIVER_DATE := TO_CHAR('SYSDATE + 2','DD.MM.YYYY');
DBMS_OUTPUT.PUT_LINE('DELIVERY DATE IS ' || TO_CHAR(SYSDATE + 2,'DD.MM.YYYY'));
ELSE
DBMS_OUTPUT.PUT_LINE('DELIVERY DATE ' || TO_CHAR(SYSDATE,'DD.MM.YYYY'));
NULL;
END IF;
END;
/