help about dateadd

• aysegul

  Right there with Babe

  Points: 778

  More actions

  January 22, 2008 at 1:09 am

  #69706

  Hi All,

  I need help about the syntax of the sql as below

  When I try to Execute the tsql as below I get the error message

  declare @IlkTarih datetime

  set @IlkTarih='01.01.2008'

  select dateadd(dd,1,convert(datetime,@IlkTarih,103))

  Msg 242, Level 16, State 3, Line 5

  The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

  Kind regards

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  January 22, 2008 at 1:19 am

  #770363

  I don't think points are valid date separator for style 103.

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  January 22, 2008 at 1:39 am

  #770368

  I am able to execute without any problem. I tried on sql server 2005

  See the following code

  declare @a datetime

  set @='01.01.2008'

  select dateadd(dd,1,convert(datetime,@a,103))

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 22, 2008 at 2:06 am

  #770377

  vyas (1/22/2008)

  ---

  I am able to execute without any problem. I tried on sql server 2005

  See the following code

  declare @a datetime

  set @='01.01.2008'

  select dateadd(dd,1,convert(datetime,@a,103))

  This post is in SQL Server 2000 forum ;).

  I tried it in 2000 and it seems to be working. Is it anything related to SET options (Ansi...) etc although i tried that also.

  "Keep Trying"

• Jeff Moden

  SSC Guru

  Points: 1004406

  More actions

  January 22, 2008 at 5:04 am

  #770423

  I hate cross posting...

  Anyway, like I said on the other forum, the correct date format number is NOT 103... it's 104. Check out Books Online under CONVERT.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)