ORACLE:

SELECT ename, hiredate "DATE",
EXTRACT(DAY FROM HIREDATE)"HDAY",
 to_char(to_date(HIREDATE,'dd/mm/yyyy'), 'Dy')"Day 0", to_char(to_date((HIREDATE + interval '6' day),'dd/mm/yyyy'), 'Dy')"Day 6" , to_char(to_date((HIREDATE + interval '7' day),'dd/mm/yyyy'), 'Dy')"Day 7" FROM emp where rownum < 7

 
row : 2 

SELECT ename, hiredate "DATE", EXTRACT(DAY FROM HIREDATE) "HDAY" , to_char(to_date(HIREDATE,'dd/mm/yyyy'), 'Dy')"Day", NEXT_DAY(HIREDATE, 'SAT') "H-SAT" , NEXT_DAY(HIREDATE, 'SUN') "H-SUN" , NEXT_DAY(HIREDATE, 'MON') "H-MON" FROM emp where rownum < 7
SELECT ename, hiredate "DATE", EXTRACT(DAY FROM HIREDATE) "HDAY" , to_char(to_date(HIREDATE,'dd/mm/yyyy'), 'Dy')"Day" , NEXT_DAY(HIREDATE, 'MON') "H-MON" FROM emp where rownum < 7
ORACLE