Oracle 21c

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

CREATE TABLE nifty_50 ("DATE", Close) AS
SELECT DATE '2022-04-07', 17763.40 FROM DUAL UNION ALL
SELECT DATE '2022-04-06', 17807.65 FROM DUAL UNION ALL
SELECT DATE '2022-04-05', 17957.40 FROM DUAL UNION ALL
SELECT DATE '2022-04-04', 18053.40 FROM DUAL UNION ALL
SELECT DATE '2022-04-01', 17670.45 FROM DUAL UNION ALL
SELECT DATE '2022-03-31', 17464.75 FROM DUAL;
6 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
select  "DATE",
        close,
        TO_CHAR("DATE", 'fmDay') as day_name
from    nifty_50;


DATE
CLOSE
DAY_NAME


2022-04-07 00:00:00
17763.4
Thursday

2022-04-06 00:00:00
17807.65
Wednesday

2022-04-05 00:00:00
17957.4
Tuesday

2022-04-04 00:00:00
18053.4
Monday

2022-04-01 00:00:00
17670.45
Friday

2022-03-31 00:00:00
17464.75
Thursday

DATE	CLOSE	DAY_NAME
2022-04-07 00:00:00	17763.4	Thursday
2022-04-06 00:00:00	17807.65	Wednesday
2022-04-05 00:00:00	17957.4	Tuesday
2022-04-04 00:00:00	18053.4	Monday
2022-04-01 00:00:00	17670.45	Friday
2022-03-31 00:00:00	17464.75	Thursday