You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DATE_ADD function Error

Accepted answer
45
Views
3
Comments

Summary:

Hi Everyone!

I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me what i am missing here?

Query used:

SELECT  DATE_ADD(ppos.DATE_START, INTERVAL 60 YEAR) AS RTM, 

papf.person_number

FROM per_periods_of_service ppos, 

per_all_people_f papf

where 

1=1

and ppos.person_id = papf.person_id

Error Thrown:



Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!