CODEWITHSUNDEEP
sqlsql-serverdynamic-sql
Priya
Priya

Reputation: 203

Dynamic SQl throwing conversion issue with datetime

The below code throwing 'Conversion failed when converting date and/or time from character string'. Here i am trying to from some Dynamic SQL

  DECLARE @TODELETEDATE DATETIME
  BEGIN
    SET @TODELETEDATE =GETDATE()-5

    PRINT '<' +  @TODELETEDATE 
 END

Upvotes: 0

Views: 45

Answers (1)

M.Ali
M.Ali

Reputation: 69524

You are concatenating datetime value to a string that's why it is failing.

DECLARE @TODELETEDATE DATETIME
  BEGIN
    SET @TODELETEDATE =GETDATE()-5

    PRINT '<' +  CONVERT(VARCHAR(19),@TODELETEDATE ,120)
 END

Upvotes: 4

Related Questions