Problem Statement:
One of the view creation scripts in our deployment failed continuously with the below exception:
Invalid parameter 1 specified for datediff.
Incorrect syntax near the keyword ‘AS’.
The root cause of this error is as below.
FLOOR((DATEDIFF("W",ml.column1,ML.column2)+1)/7) AS aliasname
Solution:
FLOOR((DATEDIFF(W,ml.column1,ML.column2)+1)/7) AS aliasname
The change is that the datepart has been modified to remove the double quote.