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')
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:
Post Comments (Atom)
No comments:
Post a Comment