ORACLE:
SELECT ename, hiredate "DATE", |
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 |