CODEWITHSUNDEEP
sqlsql-update
htm11h
htm11h

Reputation: 1779

Date conversion error on UPDATE command

I have a stored procedure that is throwing an error on an UPDATE command here are the pertinent lines of code.

DECLARE @submitDate1 DATETIME;
SET @submitDate1 = GETDATE()

   SET @sql = 'UPDATE ' + @currTable + ' SET [lang_String] = ''' + @lang_String + ''', [date_Changed] = ''' +  @submitDate1 + ''', [prev_LangString] = ''' + @prev_LangString + ''', [needsTranslation] = ''' + @needsTranslation + ''' WHERE [ID] = ' + CAST(@ID as nvarchar(10)) + '; '
   EXEC(@sql)

Here is the error... Conversion failed when converting date and/or time from character string.

Upvotes: 1

Views: 302

Answers (2)

Djay
Djay

Reputation: 11

use 

convert(varchar,@submitDate1)

at the place where you have used @submitDate1 variable.

SQL does not do implicit conversion from date to string!

Upvotes: 1

Guffa
Guffa

Reputation: 700670

You have to convert the date into a string before concatenating it to the other strings:

... = ''' +  convert(varchar(20), @submitDate1) + ''', [...

Upvotes: 4

Related Questions