Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.
Date_Add or Date_Sub
I am trying to add an expression to a BI container.
DATE_ADD(ARVLDATE,INTERVAL
this continues to return an error of "incorrect syntax near '2'
screen shots attached
DATE_ADD(ARVLDATE,INTERVAL
this continues to return an error of "incorrect syntax near '2'
screen shots attached
Asked:
1 Solution
If you are using mysql as James indicated, then the syntax you are using should work.
If however, you are using SQL Server, then date_add is not a valid sql server syntax.
dateAdd(day, 2, ARVLDATE)
If however, you are using SQL Server, then date_add is not a valid sql server syntax.
dateAdd(day, 2, ARVLDATE)
I believe you are using a MYSQL syntax..which is different from MS SQL Syntax
Now, In which BI container are you trying to use this function ? unless you are trying to use this in a ADO.NET source container connected to MYSQL database.. in which case syntax seems to be correct.. If the below does not work,post error msg or screen shot of the error
try this
DATEADD("DD",2,ARVLDATE) -- if you are using it as an expression in SSIS
OR
DATEADD(DD,2,ARVLDATE) -- If you are using it in a SQL Query
Now, In which BI container are you trying to use this function ? unless you are trying to use this in a ADO.NET source container connected to MYSQL database.. in which case syntax seems to be correct.. If the below does not work,post error msg or screen shot of the error
try this
DATEADD("DD",2,ARVLDATE) -- if you are using it as an expression in SSIS
OR
DATEADD(DD,2,ARVLDATE) -- If you are using it in a SQL Query
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
I don't see any screenshots, or anything else, attached to your post.
You posted this in the MS SQL section. Is DATE_ADD an MS SQL function? It wasn't in the past, but maybe it's been added. From a little searching I did, DATE_ADD seems to be a MySQL function, so maybe this should be in the MySQL zone?
Apart from that, your syntax seems OK, so I don't know why you'd be getting an error. I assume that ARVLDATE is a date or datetime column, and if it wasn't, I'd expect an error on that, not the 2.
Any chance you're using MS SQL and actually using DATEADD, instead of DATE_ADD? The DATEADD arguments would be:
DATEADD(day, 2, ARVLDATE)
James