how to sort day of week starting by Monday?

Question

select first_name name, hire_date , TO_CHAR(hire_date, 'day') Day
from employees
--------------------------------------------------------
my above query is working well except that I want to sort rows order by day of week starting from Monday.
/

Answer 1

The only way that I can think of is to add a new alphanumeric field to the record. For example, set Monday = A, Tuesday = B, ... Sunday = 7. Then sort on the new field.