using datetime variable in dynamic sql

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  October 31, 2005 at 2:50 pm

  #89876

  Hi,

  I am trying to use datetime variable inside dynamic sql. it is giving me this error

  Syntax error converting datetime from character string.

  here is the sample code that I am running...

  DECLARE @pStart DATETIME

  SET @pStart = '10/27/2005'

  DECLARE @queryString VARCHAR(8000)

  SET @queryString = 'SELECT ' + @pStart

  SELECT @queryString

  Please let me know where I am doing wrong?

  Thanks,

  Sridhar.

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  October 31, 2005 at 3:02 pm

  #601431

  in dynamic SQL you are building a string so you need to treat it that way as you would in QA:

  What you're trying to create is   SELECT '10/27/2005'

  So

  SET @query_string = 'SELECT ''' + CONVERT( VARCHAR(10), @pstart ) + ''''

   

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  October 31, 2005 at 3:09 pm

  #601432

  Thanks John.