Date conditions in dynamic sql

• Mardy Gazzo

  Ten Centuries

  Points: 1177

  More actions

  April 27, 2004 at 9:26 am

  #111065

  I'm developing a stored procedure using dynamic sql and I keep getting the following error:  Syntax error converting datetime from character string.

  I'm passing a set of parameters to the sp with defaults

  @ServiceCallStartDate  ='2000-01-01',

  @ServiceCallEndDate  ='2003-12-31'

  In my where clause I have:

  IF @ServiceCallStartDate <> ''

  set @v_Query = @v_Query + ' si.Order_Date > ''' + @ServiceCallStartDate + ''''

  I have other parameters that are char datatypes and this format works fine.

  Please help.

  Thank you

   

   

• rs

  SSCrazy

  Points: 2819

  More actions

  April 27, 2004 at 10:29 am

  #504363

  Try This,

  set @v_Query = @v_Query + ' si.Order_Date > ''' + CONVERT(CHAR(10),@ServiceCallStartDate,101) + ''''

   

  Thanks,

   

• Mardy Gazzo

  Ten Centuries

  Points: 1177

  More actions

  April 27, 2004 at 10:43 am

  #504366

  thank you