From dc733bcea64a45f8aae3fa6f20392c8a41278ce1 Mon Sep 17 00:00:00 2001 From: Guillaume DOUMENC Date: Tue, 12 Jan 2016 04:46:32 +0000 Subject: Remove quote on first DATEPART paramater (cherry picked from commit c4f415d97988bc8a8d901b150bfb67571f29712e) - changelog for pr bitbucket:70, fixes #3624 (cherry picked from commit 215167d8d38a381d27c8448f5c6e50c70b9ba0cc) --- lib/sqlalchemy/dialects/mssql/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/dialects') diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index f3d20b3aa..8fdb8ee87 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -1181,7 +1181,7 @@ class MSSQLCompiler(compiler.SQLCompiler): def visit_extract(self, extract, **kw): field = self.extract_map.get(extract.field, extract.field) - return 'DATEPART("%s", %s)' % \ + return 'DATEPART(%s, %s)' % \ (field, self.process(extract.expr, **kw)) def visit_savepoint(self, savepoint_stmt): -- cgit v1.2.1