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...
Type: Posts; User: bhagyeshpatel_2002; Keyword(s):
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...