Answer to Question #248738 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.

Answer 1

DECLARE
    date1 DATE := TO_DATE('&new_dt', 'DD-MON-YYYY');
    day VARCHAR2(15);
    BEGIN
    day := RTRIM(TO_CHAR(date1, 'DAY'));
    IF day IN ('SATURDAY', 'SUNDAY') THEN
    dbms_output.new_line;
    DBMS_OUTPUT.PUT_LINE 
    ('The day of the given date is '||day||' and it falls on weekend');
    ELSE
    dbms_output.new_line;
    DBMS_OUTPUT.PUT_LINE ('The day of the given date is '||day||' and it does not fall on the weekend');
    END IF;
    DBMS_OUTPUT.PUT_LINE ('Execution  Successful');
END;