blazted
asked on
Adding Months to the DATE, Nested Function
I have a select statement and I want to add some months to my SQL statement. I need to Add 6 Months to the Hire_date.
I cannot get a nested function to work here.
SELECT LAST_NAME, HIRE_DATE,
TO_CHAR(HIRE_DATE, 'DAY, "the" fmDdspth "of" Month, YYYY')REVIEW
FROM EMPLOYEES;
I cannot get this to work correctlly.
Thanks
I cannot get a nested function to work here.
SELECT LAST_NAME, HIRE_DATE,
TO_CHAR(HIRE_DATE, 'DAY, "the" fmDdspth "of" Month, YYYY')REVIEW
FROM EMPLOYEES;
I cannot get this to work correctlly.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER