Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Course Of The Month
3 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Date_Add or Date_Sub
Posted on 2012-03-20
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
I don't know if I can help, but FWIW:
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
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
Active 5 days ago
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month3 days, 17 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.