‘Syntax error converting datetime from character string’ with M SQL Stored Procedure
August 21st, 2008 - by admin
Are you getting this error message:
‘Syntax error converting datetime from character string’
Solution:
Make sure you cast the datetime variables as nvarchar if you are using the exec command!
Example Code:
CREATE PROCEDURE CRM_ComplaintStageCompsMembersClosedMultiple
@sQStartDate datetime,
@sQEndDate datetime
AS
Begin
set @strsql = ” INSERT #TEMPDISTINCT(id, posted_timestamp, dateresponded, sent_timestamp, serviceunit, service, dept)”+
“ SELECT * FROM `table` Where r.posted_timestamp >= ‘” + cast(@sQStartDate as nvarchar(50)) + “‘ AND r.posted_timestamp < ‘” + cast(@sQEndDate as nvarchar(50)) + “‘”
exec sp_executesql @strsql
END
GO