SELECT last_name, hire_date, to_char(hire_date,'DAY') DAY from employees ORDER BY TO_CHAR(hire_date-1,'D');

OR

SELECT last_name, hire_date, "DAY" from
(select case when...