- changed title to Datepart wrong first parameter on MSSQL engine
Datepart wrong first parameter on MSSQL engine
Issue #3624
resolved
Using mssql+pyodbc and extract expression, I get :
[FreeTDS][SQL Server]Invalid parameter 1 specified for datepart.
The reason is that first parameter don't need quotes. MMSQL ref : https://technet.microsoft.com/en-us/library/aa258265%28v=sql.80%29.aspx
I will provide a pull for fixing it
Comments (5)
-
reporter -
repo owner - changed status to resolved
- changelog for pr bitbucket:70, fixes
#3624
→ <<cset 215167d8d38a>>
-
repo owner Remove quote on first DATEPART paramater (cherry picked from commit c4f415d97988bc8a8d901b150bfb67571f29712e) - changelog for pr bitbucket:70, fixes
#3624(cherry picked from commit 215167d8d38a381d27c8448f5c6e50c70b9ba0cc)
→ <<cset dc733bcea64a>>
-
repo owner thanks for reporting!
-
reporter Thanks for your great job and product...!
- Log in to comment