Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
DATE_ADD function Error
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):
Tagged:
1