Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.
Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.
Share
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.
get_day VARCHAR2(15);
BEGIN
get_day := RTRIM(TO_CHAR(dt1, ‘DAY’));
IF get_day IN (‘SATURDAY’, ‘SUNDAY’) THEN
. . . .. . . . .. .
THE ANSWER IS IN THE ATTACHMENT: