Syntax error converting datetime from character string

• suresh-216682

  SSC-Addicted

  Points: 491

  More actions

  October 13, 2006 at 6:18 am

  #69425

  select 'dateadd(dd,1,'+ getdate() + ')'

   

  I am getting a syntax error

  Syntax error converting datetime from character string

   

  How do i overcome this

• David Burrows

  SSC Guru

  Points: 65143

  More actions

  October 13, 2006 at 7:23 am

  #665721

  What are you trying to achieve

  SELECT DATEADD(dd,1,GETDATE())

  or

  SELECT 'DATEADD(dd,1,'''+ CAST(GETDATE() as char(11)) + ''')'

  Far away is close at hand in the images of elsewhere.
  Anon.