Hire date and salary review date
Display each employee’s last name, hire date, and salary review date, which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format similar to “Monday, the Thirty-First of July, 2000.”
[b]Question asked by visitor clipso[/b]
Re: Hire date and salary review date
Kindly post what / how you have tried to solve the problem ,with your table structure.
Re: Hire date and salary review date
[code]
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'))||' of '||
INITCAP(TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'MON'))||' '||
(TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'YYYY') Review
From Emp;
[/code]
Re: Hire date and salary review date
SELECT ename,hiredate,
TO_CHAR(NEXT_DAY(ADD_MONTHS(hiredate, 6), ’Monday’),’"Monday, the " fmDdspth "of" Month YYYY ’) "REVIEW"
FROM emp;
:)
Re: Hire date and salary review date
try the below query,
select ename,hiredate,sal,
to_char(next_day(trunc(add_months(hiredate,6),'mm'),'monday'),'DAY,"THE" DDSP "OF" MONTH YYYY') Review_date
FROM emp.
Re: Hire date and salary review date
[code]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'))||' of '||
INITCAP(TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'MON'))||' '||
(TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE,6),'MONDAY') - 7,'YYYY') Review
FROM Emp;[/code]