The SQL below is useful to help you on doing conversion from date to day based on sysdate or any given date input: -

Conver Date To Day SQL

a) select to_char(sysdate,’DAY’) from dual;

b) select to_char(sysdate,’DY’) from dual;

c) select to_char(sysdate,’D') from dual;