Unanswered: Sorting Days of week with Monday first
Hi there !
I have to display a name, hiredate and day of the week on which an employee started and order the results by the day of the week STARTING WITH MONDAY. How do I get the day of the week in the correct order?
With the following query, am able to sort the record with SUNDAY first:
Select ename, hiredate, to_char(hiredate,'day') from emp order by to_char(hiredate,'d')