SELECT Ename,Hiredate,
TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'DAY')||', the '||
INITCAP(TO_CHAR(to_DATE(TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'dd'),'J'),'JSP'))||'...
Type: Posts; User: Filistin Peter; Keyword(s):
SELECT Ename,Hiredate,
TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'DAY')||', the '||
INITCAP(TO_CHAR(to_DATE(TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'dd'),'J'),'JSP'))||'...