From c4f415d97988bc8a8d901b150bfb67571f29712e Mon Sep 17 00:00:00 2001 From: Guillaume DOUMENC Date: Tue, 12 Jan 2016 04:46:32 +0000 Subject: [PATCH] Remove quote on first DATEPART paramater --- lib/sqlalchemy/dialects/mssql/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 1ee328e834..815529c88d 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -1157,7 +1157,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): -- 2.47.2