You can translate the question and the replies:

Denodo addmonth equivalent

Hi I have a teradata condition as: select (EXTRACT(MONTH FROM ADD_MONTH(DATE , 0) -6) FROM TABLE_NAME. what will be the equivalent of this query in denodo, as denodo is throwing error Thanks
Extra Functions monthfunction
user
27-11-2023 04:09:59 -0500
code

3 Answers

Hi, This appears to be very similar to a previously answered question: https://community.denodo.com/answers/question/details?questionId=906Du00000001XhIAI&titleDenodo%20equivalent%20in%20Teradata%20Addmonth(DATE) Hope this helps!
Denodo Team
28-11-2023 19:46:06 -0500
code
Hi, The solution given there does not match the output Im looking for. Im current passsing it as: select (EXTRACT(MONTH FROM ADD_MONTH(DATE , -6) FROM TABLE_NAME. And this is not giving the expected result. Please do let me know how the syntax for the above query will be as Thanks
user
17-12-2023 03:41:08 -0500
Hi, Are you getting an incorrect result or an error from the output? I noticed that the query here appears to have mismatched parentheses - your query with corrected syntax might look something like: `SELECT EXTRACT (MONTH FROM ADDMONTH(DATE,-6)) FROM TABLE_NAME` Otherwise, you may find [Teradata SQL to Denodo VQL Quick Reference](https://community.denodo.com/kb/en/view/document/Teradata%20SQL%20to%20Denodo%20VQL%20Quick%20Reference) in the Knowledge Base useful for this situation. Hope this helps!
Denodo Team
21-12-2023 13:51:39 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here