1- display each employee’slast name, hire date, and salary review date. Which is
ID: 3610824 • Letter: 1
Question
1- display each employee’slast name, hire date, and salary review date. Which is the firstMonday after six months of service? Label the column REVIEW formatthe dates to appear in the format similar to Monday. Thethirty-first of July, 2000’’.
LAST_NAME
HIRE_DATE
REVIEW
King
17-jun-87
Monday, the twenty –first of December,1987
Kochar
21-sep-89
Monday, the twenty-sixth of march,1990
LAST_NAME
HIRE_DATE
REVIEW
King
17-jun-87
Monday, the twenty –first of December,1987
Kochar
21-sep-89
Monday, the twenty-sixth of march,1990
Explanation / Answer
Dear.., 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; I Hope this will help you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.