Add One Day to a Date

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  February 10, 2010 at 7:08 am

  #386291

  Hello Everyone

  Is anyone snowed in like me?

  I am trying to add a single day to a date data type value

  DECLARE @TodaysDate Date

  DECLARE @TomorrowsDate Date

  SET @TodaysDate = 2010-2-14

  SET @TomorrowsDate = (@TodaysDate + 1)

  I am receiving this error:

  Operand type clash: date is incompatible with int

  I cannot find, or do not understand what the BOL states about this conversion.

  Can someone point me in the correct direction?

  Thanks

  Andrew SQLDBA

• wschampheleer

  SSCertifiable

  Points: 5504

  More actions

  February 10, 2010 at 7:17 am

  #1116797

  Try this

  DECLARE @TodaysDate Date

  DECLARE @TomorrowsDate Date

  SET @TodaysDate = '20100214'

  SET @TomorrowsDate = DATEADD(dd,1,@TodaysDate)

  Regards,

  Willem
  http://wschampheleer.wordpress.com[/url]

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 10, 2010 at 7:18 am

  #1116799

  AndrewSQLDBA (2/10/2010)

  ---

  Hello Everyone

  Is anyone snowed in like me?

  I am trying to add a single day to a date data type value

  DECLARE @TodaysDate Date

  DECLARE @TomorrowsDate Date

  SET @TodaysDate = 2010-2-14

  SET @TomorrowsDate = (@TodaysDate + 1)

  I am receiving this error:

  Operand type clash: date is incompatible with int

  I cannot find, or do not understand what the BOL states about this conversion.

  Can someone point me in the correct direction?

  Thanks

  Andrew SQLDBA

  try: set @TomorrowsDate = dateadd(dd, 1, @TodaysDate)

  Edit: Also make this change: SET @TodaysDate = '2010-2-14'

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  February 10, 2010 at 8:17 am

  #1116859

  Whoooops!

  I forget the quotes around the date. But you get the jest of it. I know the date is supposed to have quotes.

  Thanks Everyone. I will try your suggestions

  Is that listed in the BOL? Or did I just not see it in the Date & Time data type section?

  Andrew SQLDBA

• wschampheleer

  SSCertifiable

  Points: 5504

  More actions

  February 10, 2010 at 8:22 am

  #1116864

  dateadd in BOL

  and a great post about dates in T-SQL

  Regards,

  Willem
  http://wschampheleer.wordpress.com[/url]

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  February 10, 2010 at 8:25 am

  #1116868

  Thanks, I hope this can help someone else also.

  I will go back and read it again. Maybe i looked right over it

  Andrew SQLDBA