SELECT ename,hiredate,
TO_CHAR(NEXT_DAY(ADD_MONTHS(hiredate, 6), ’Monday’),’"Monday, the " fmDdspth "of" Month YYYY ’) "REVIEW"
FROM emp;
:)
Type: Posts; User: sweetestdrug; Keyword(s):
SELECT ename,hiredate,
TO_CHAR(NEXT_DAY(ADD_MONTHS(hiredate, 6), ’Monday’),’"Monday, the " fmDdspth "of" Month YYYY ’) "REVIEW"
FROM emp;
:)