i am using this statement
select dateadd(dd,1,20010331)
and it's throwing an error
Arithmetic overflow error converting expression to data type datetime.
what's wrong?sql server wants to have date strings, not integers
select dateadd(dd,1,'2001-03-31')|||i am using this statement
select dateadd(dd,1,20010331)
and it's throwing an error
Arithmetic overflow error converting expression to data type datetime.
what's wrong?You're missing quotes:
select dateadd(dd,1,'20010331')
Showing posts with label throwing. Show all posts
Showing posts with label throwing. Show all posts
Wednesday, March 28, 2012
how to form query?
Labels:
converting,
database,
dateadd,
error,
errorarithmetic,
expression,
form,
microsoft,
mysql,
oracle,
overflow,
query,
server,
sql,
statementselect,
throwing,
type
Subscribe to:
Posts (Atom)