Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with cte (v_run_date) as (

select date '2018-12-31' + level

from dual

connect by level <= 365

)

select v_run_date,

to_char(v_run_date, 'Dy', 'NLS_DATE_LANGUAGE=ENGLISH') as dy,

case

when last_day(v_run_date) - v_run_date <= 3

and to_char(v_run_date, 'Dy', 'NLS_DATE_LANGUAGE=ENGLISH') in ('Fri', 'Sat', 'Sun')

and to_char(last_day(v_run_date), 'Dy', 'NLS_DATE_LANGUAGE=ENGLISH') in ('Fri', 'Sat', 'Sun')

then next_day(trunc(v_run_date, 'IW'), 'THURSDAY')

else v_run_date

end as adjusted_date

from cte;

V_RUN_DATE	DY	ADJUSTED_DATE
01-JAN-19	Tue	01-JAN-19
02-JAN-19	Wed	02-JAN-19
03-JAN-19	Thu	03-JAN-19
04-JAN-19	Fri	04-JAN-19
05-JAN-19	Sat	05-JAN-19
06-JAN-19	Sun	06-JAN-19
07-JAN-19	Mon	07-JAN-19
08-JAN-19	Tue	08-JAN-19
09-JAN-19	Wed	09-JAN-19
10-JAN-19	Thu	10-JAN-19
11-JAN-19	Fri	11-JAN-19
12-JAN-19	Sat	12-JAN-19
13-JAN-19	Sun	13-JAN-19
14-JAN-19	Mon	14-JAN-19
15-JAN-19	Tue	15-JAN-19
16-JAN-19	Wed	16-JAN-19
17-JAN-19	Thu	17-JAN-19
18-JAN-19	Fri	18-JAN-19
19-JAN-19	Sat	19-JAN-19
20-JAN-19	Sun	20-JAN-19
21-JAN-19	Mon	21-JAN-19
22-JAN-19	Tue	22-JAN-19
23-JAN-19	Wed	23-JAN-19
24-JAN-19	Thu	24-JAN-19
25-JAN-19	Fri	25-JAN-19
26-JAN-19	Sat	26-JAN-19
27-JAN-19	Sun	27-JAN-19
28-JAN-19	Mon	28-JAN-19
29-JAN-19	Tue	29-JAN-19
30-JAN-19	Wed	30-JAN-19
31-JAN-19	Thu	31-JAN-19
01-FEB-19	Fri	01-FEB-19
02-FEB-19	Sat	02-FEB-19
03-FEB-19	Sun	03-FEB-19
04-FEB-19	Mon	04-FEB-19
05-FEB-19	Tue	05-FEB-19
06-FEB-19	Wed	06-FEB-19
07-FEB-19	Thu	07-FEB-19
08-FEB-19	Fri	08-FEB-19
09-FEB-19	Sat	09-FEB-19
10-FEB-19	Sun	10-FEB-19
11-FEB-19	Mon	11-FEB-19
12-FEB-19	Tue	12-FEB-19
13-FEB-19	Wed	13-FEB-19
14-FEB-19	Thu	14-FEB-19
15-FEB-19	Fri	15-FEB-19
16-FEB-19	Sat	16-FEB-19
17-FEB-19	Sun	17-FEB-19
18-FEB-19	Mon	18-FEB-19
19-FEB-19	Tue	19-FEB-19
20-FEB-19	Wed	20-FEB-19
21-FEB-19	Thu	21-FEB-19
22-FEB-19	Fri	22-FEB-19
23-FEB-19	Sat	23-FEB-19
24-FEB-19	Sun	24-FEB-19
25-FEB-19	Mon	25-FEB-19
26-FEB-19	Tue	26-FEB-19
27-FEB-19	Wed	27-FEB-19
28-FEB-19	Thu	28-FEB-19
01-MAR-19	Fri	01-MAR-19
02-MAR-19	Sat	02-MAR-19
03-MAR-19	Sun	03-MAR-19
04-MAR-19	Mon	04-MAR-19
05-MAR-19	Tue	05-MAR-19
06-MAR-19	Wed	06-MAR-19
07-MAR-19	Thu	07-MAR-19
08-MAR-19	Fri	08-MAR-19
09-MAR-19	Sat	09-MAR-19
10-MAR-19	Sun	10-MAR-19
11-MAR-19	Mon	11-MAR-19
12-MAR-19	Tue	12-MAR-19
13-MAR-19	Wed	13-MAR-19
14-MAR-19	Thu	14-MAR-19
15-MAR-19	Fri	15-MAR-19
16-MAR-19	Sat	16-MAR-19
17-MAR-19	Sun	17-MAR-19
18-MAR-19	Mon	18-MAR-19
19-MAR-19	Tue	19-MAR-19
20-MAR-19	Wed	20-MAR-19
21-MAR-19	Thu	21-MAR-19
22-MAR-19	Fri	22-MAR-19
23-MAR-19	Sat	23-MAR-19
24-MAR-19	Sun	24-MAR-19
25-MAR-19	Mon	25-MAR-19
26-MAR-19	Tue	26-MAR-19
27-MAR-19	Wed	27-MAR-19
28-MAR-19	Thu	28-MAR-19
29-MAR-19	Fri	28-MAR-19
30-MAR-19	Sat	28-MAR-19
31-MAR-19	Sun	28-MAR-19
01-APR-19	Mon	01-APR-19
02-APR-19	Tue	02-APR-19
03-APR-19	Wed	03-APR-19
04-APR-19	Thu	04-APR-19
05-APR-19	Fri	05-APR-19
06-APR-19	Sat	06-APR-19
07-APR-19	Sun	07-APR-19
08-APR-19	Mon	08-APR-19
09-APR-19	Tue	09-APR-19
10-APR-19	Wed	10-APR-19
11-APR-19	Thu	11-APR-19
12-APR-19	Fri	12-APR-19
13-APR-19	Sat	13-APR-19
14-APR-19	Sun	14-APR-19
15-APR-19	Mon	15-APR-19
16-APR-19	Tue	16-APR-19
17-APR-19	Wed	17-APR-19
18-APR-19	Thu	18-APR-19
19-APR-19	Fri	19-APR-19
20-APR-19	Sat	20-APR-19
21-APR-19	Sun	21-APR-19
22-APR-19	Mon	22-APR-19
23-APR-19	Tue	23-APR-19
24-APR-19	Wed	24-APR-19
25-APR-19	Thu	25-APR-19
26-APR-19	Fri	26-APR-19
27-APR-19	Sat	27-APR-19
28-APR-19	Sun	28-APR-19
29-APR-19	Mon	29-APR-19
30-APR-19	Tue	30-APR-19
01-MAY-19	Wed	01-MAY-19
02-MAY-19	Thu	02-MAY-19
03-MAY-19	Fri	03-MAY-19
04-MAY-19	Sat	04-MAY-19
05-MAY-19	Sun	05-MAY-19
06-MAY-19	Mon	06-MAY-19
07-MAY-19	Tue	07-MAY-19
08-MAY-19	Wed	08-MAY-19
09-MAY-19	Thu	09-MAY-19
10-MAY-19	Fri	10-MAY-19
11-MAY-19	Sat	11-MAY-19
12-MAY-19	Sun	12-MAY-19
13-MAY-19	Mon	13-MAY-19
14-MAY-19	Tue	14-MAY-19
15-MAY-19	Wed	15-MAY-19
16-MAY-19	Thu	16-MAY-19
17-MAY-19	Fri	17-MAY-19
18-MAY-19	Sat	18-MAY-19
19-MAY-19	Sun	19-MAY-19
20-MAY-19	Mon	20-MAY-19
21-MAY-19	Tue	21-MAY-19
22-MAY-19	Wed	22-MAY-19
23-MAY-19	Thu	23-MAY-19
24-MAY-19	Fri	24-MAY-19
25-MAY-19	Sat	25-MAY-19
26-MAY-19	Sun	26-MAY-19
27-MAY-19	Mon	27-MAY-19
28-MAY-19	Tue	28-MAY-19
29-MAY-19	Wed	29-MAY-19
30-MAY-19	Thu	30-MAY-19
31-MAY-19	Fri	30-MAY-19
01-JUN-19	Sat	01-JUN-19
02-JUN-19	Sun	02-JUN-19
03-JUN-19	Mon	03-JUN-19
04-JUN-19	Tue	04-JUN-19
05-JUN-19	Wed	05-JUN-19
06-JUN-19	Thu	06-JUN-19
07-JUN-19	Fri	07-JUN-19
08-JUN-19	Sat	08-JUN-19
09-JUN-19	Sun	09-JUN-19
10-JUN-19	Mon	10-JUN-19
11-JUN-19	Tue	11-JUN-19
12-JUN-19	Wed	12-JUN-19
13-JUN-19	Thu	13-JUN-19
14-JUN-19	Fri	14-JUN-19
15-JUN-19	Sat	15-JUN-19
16-JUN-19	Sun	16-JUN-19
17-JUN-19	Mon	17-JUN-19
18-JUN-19	Tue	18-JUN-19
19-JUN-19	Wed	19-JUN-19
20-JUN-19	Thu	20-JUN-19
21-JUN-19	Fri	21-JUN-19
22-JUN-19	Sat	22-JUN-19
23-JUN-19	Sun	23-JUN-19
24-JUN-19	Mon	24-JUN-19
25-JUN-19	Tue	25-JUN-19
26-JUN-19	Wed	26-JUN-19
27-JUN-19	Thu	27-JUN-19
28-JUN-19	Fri	27-JUN-19
29-JUN-19	Sat	27-JUN-19
30-JUN-19	Sun	27-JUN-19
01-JUL-19	Mon	01-JUL-19
02-JUL-19	Tue	02-JUL-19
03-JUL-19	Wed	03-JUL-19
04-JUL-19	Thu	04-JUL-19
05-JUL-19	Fri	05-JUL-19
06-JUL-19	Sat	06-JUL-19
07-JUL-19	Sun	07-JUL-19
08-JUL-19	Mon	08-JUL-19
09-JUL-19	Tue	09-JUL-19
10-JUL-19	Wed	10-JUL-19
11-JUL-19	Thu	11-JUL-19
12-JUL-19	Fri	12-JUL-19
13-JUL-19	Sat	13-JUL-19
14-JUL-19	Sun	14-JUL-19
15-JUL-19	Mon	15-JUL-19
16-JUL-19	Tue	16-JUL-19
17-JUL-19	Wed	17-JUL-19
18-JUL-19	Thu	18-JUL-19
19-JUL-19	Fri	19-JUL-19
20-JUL-19	Sat	20-JUL-19
21-JUL-19	Sun	21-JUL-19
22-JUL-19	Mon	22-JUL-19
23-JUL-19	Tue	23-JUL-19
24-JUL-19	Wed	24-JUL-19
25-JUL-19	Thu	25-JUL-19
26-JUL-19	Fri	26-JUL-19
27-JUL-19	Sat	27-JUL-19
28-JUL-19	Sun	28-JUL-19
29-JUL-19	Mon	29-JUL-19
30-JUL-19	Tue	30-JUL-19
31-JUL-19	Wed	31-JUL-19
01-AUG-19	Thu	01-AUG-19
02-AUG-19	Fri	02-AUG-19
03-AUG-19	Sat	03-AUG-19
04-AUG-19	Sun	04-AUG-19
05-AUG-19	Mon	05-AUG-19
06-AUG-19	Tue	06-AUG-19
07-AUG-19	Wed	07-AUG-19
08-AUG-19	Thu	08-AUG-19
09-AUG-19	Fri	09-AUG-19
10-AUG-19	Sat	10-AUG-19
11-AUG-19	Sun	11-AUG-19
12-AUG-19	Mon	12-AUG-19
13-AUG-19	Tue	13-AUG-19
14-AUG-19	Wed	14-AUG-19
15-AUG-19	Thu	15-AUG-19
16-AUG-19	Fri	16-AUG-19
17-AUG-19	Sat	17-AUG-19
18-AUG-19	Sun	18-AUG-19
19-AUG-19	Mon	19-AUG-19
20-AUG-19	Tue	20-AUG-19
21-AUG-19	Wed	21-AUG-19
22-AUG-19	Thu	22-AUG-19
23-AUG-19	Fri	23-AUG-19
24-AUG-19	Sat	24-AUG-19
25-AUG-19	Sun	25-AUG-19
26-AUG-19	Mon	26-AUG-19
27-AUG-19	Tue	27-AUG-19
28-AUG-19	Wed	28-AUG-19
29-AUG-19	Thu	29-AUG-19
30-AUG-19	Fri	29-AUG-19
31-AUG-19	Sat	29-AUG-19
01-SEP-19	Sun	01-SEP-19
02-SEP-19	Mon	02-SEP-19
03-SEP-19	Tue	03-SEP-19
04-SEP-19	Wed	04-SEP-19
05-SEP-19	Thu	05-SEP-19
06-SEP-19	Fri	06-SEP-19
07-SEP-19	Sat	07-SEP-19
08-SEP-19	Sun	08-SEP-19
09-SEP-19	Mon	09-SEP-19
10-SEP-19	Tue	10-SEP-19
11-SEP-19	Wed	11-SEP-19
12-SEP-19	Thu	12-SEP-19
13-SEP-19	Fri	13-SEP-19
14-SEP-19	Sat	14-SEP-19
15-SEP-19	Sun	15-SEP-19
16-SEP-19	Mon	16-SEP-19
17-SEP-19	Tue	17-SEP-19
18-SEP-19	Wed	18-SEP-19
19-SEP-19	Thu	19-SEP-19
20-SEP-19	Fri	20-SEP-19
21-SEP-19	Sat	21-SEP-19
22-SEP-19	Sun	22-SEP-19
23-SEP-19	Mon	23-SEP-19
24-SEP-19	Tue	24-SEP-19
25-SEP-19	Wed	25-SEP-19
26-SEP-19	Thu	26-SEP-19
27-SEP-19	Fri	27-SEP-19
28-SEP-19	Sat	28-SEP-19
29-SEP-19	Sun	29-SEP-19
30-SEP-19	Mon	30-SEP-19
01-OCT-19	Tue	01-OCT-19
02-OCT-19	Wed	02-OCT-19
03-OCT-19	Thu	03-OCT-19
04-OCT-19	Fri	04-OCT-19
05-OCT-19	Sat	05-OCT-19
06-OCT-19	Sun	06-OCT-19
07-OCT-19	Mon	07-OCT-19
08-OCT-19	Tue	08-OCT-19
09-OCT-19	Wed	09-OCT-19
10-OCT-19	Thu	10-OCT-19
11-OCT-19	Fri	11-OCT-19
12-OCT-19	Sat	12-OCT-19
13-OCT-19	Sun	13-OCT-19
14-OCT-19	Mon	14-OCT-19
15-OCT-19	Tue	15-OCT-19
16-OCT-19	Wed	16-OCT-19
17-OCT-19	Thu	17-OCT-19
18-OCT-19	Fri	18-OCT-19
19-OCT-19	Sat	19-OCT-19
20-OCT-19	Sun	20-OCT-19
21-OCT-19	Mon	21-OCT-19
22-OCT-19	Tue	22-OCT-19
23-OCT-19	Wed	23-OCT-19
24-OCT-19	Thu	24-OCT-19
25-OCT-19	Fri	25-OCT-19
26-OCT-19	Sat	26-OCT-19
27-OCT-19	Sun	27-OCT-19
28-OCT-19	Mon	28-OCT-19
29-OCT-19	Tue	29-OCT-19
30-OCT-19	Wed	30-OCT-19
31-OCT-19	Thu	31-OCT-19
01-NOV-19	Fri	01-NOV-19
02-NOV-19	Sat	02-NOV-19
03-NOV-19	Sun	03-NOV-19
04-NOV-19	Mon	04-NOV-19
05-NOV-19	Tue	05-NOV-19
06-NOV-19	Wed	06-NOV-19
07-NOV-19	Thu	07-NOV-19
08-NOV-19	Fri	08-NOV-19
09-NOV-19	Sat	09-NOV-19
10-NOV-19	Sun	10-NOV-19
11-NOV-19	Mon	11-NOV-19
12-NOV-19	Tue	12-NOV-19
13-NOV-19	Wed	13-NOV-19
14-NOV-19	Thu	14-NOV-19
15-NOV-19	Fri	15-NOV-19
16-NOV-19	Sat	16-NOV-19
17-NOV-19	Sun	17-NOV-19
18-NOV-19	Mon	18-NOV-19
19-NOV-19	Tue	19-NOV-19
20-NOV-19	Wed	20-NOV-19
21-NOV-19	Thu	21-NOV-19
22-NOV-19	Fri	22-NOV-19
23-NOV-19	Sat	23-NOV-19
24-NOV-19	Sun	24-NOV-19
25-NOV-19	Mon	25-NOV-19
26-NOV-19	Tue	26-NOV-19
27-NOV-19	Wed	27-NOV-19
28-NOV-19	Thu	28-NOV-19
29-NOV-19	Fri	28-NOV-19
30-NOV-19	Sat	28-NOV-19
01-DEC-19	Sun	01-DEC-19
02-DEC-19	Mon	02-DEC-19
03-DEC-19	Tue	03-DEC-19
04-DEC-19	Wed	04-DEC-19
05-DEC-19	Thu	05-DEC-19
06-DEC-19	Fri	06-DEC-19
07-DEC-19	Sat	07-DEC-19
08-DEC-19	Sun	08-DEC-19
09-DEC-19	Mon	09-DEC-19
10-DEC-19	Tue	10-DEC-19
11-DEC-19	Wed	11-DEC-19
12-DEC-19	Thu	12-DEC-19
13-DEC-19	Fri	13-DEC-19
14-DEC-19	Sat	14-DEC-19
15-DEC-19	Sun	15-DEC-19
16-DEC-19	Mon	16-DEC-19
17-DEC-19	Tue	17-DEC-19
18-DEC-19	Wed	18-DEC-19
19-DEC-19	Thu	19-DEC-19
20-DEC-19	Fri	20-DEC-19
21-DEC-19	Sat	21-DEC-19
22-DEC-19	Sun	22-DEC-19
23-DEC-19	Mon	23-DEC-19
24-DEC-19	Tue	24-DEC-19
25-DEC-19	Wed	25-DEC-19
26-DEC-19	Thu	26-DEC-19
27-DEC-19	Fri	27-DEC-19
28-DEC-19	Sat	28-DEC-19
29-DEC-19	Sun	29-DEC-19
30-DEC-19	Mon	30-DEC-19
31-DEC-19	Tue	31-DEC-19

-- just the adjusted dates