Link to home
Start Free TrialLog in
Avatar of blazted
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
ASKER CERTIFIED SOLUTION
Avatar of ishando
ishando
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of blazted
blazted

ASKER

Tahnk you, I had my () placed wrong in my Statement earlier