CODE EXAMPLE FOR SQL

get day name based on date oracle sql

SELECT
  TO_CHAR(DATE '2022-01-01', 'Day')
FROM DUAL;