From 80ce23f6fd0f14ab656d3ec82773bd0cffbd4791 Mon Sep 17 00:00:00 2001
From: Jacobo de Vera <devel@jacobodevera.com>
Date: Fri, 13 Nov 2015 16:57:41 +0100
Subject: Pass precision value to mssql.DATETIME2 when it is 0

The simple check on the precision results in DATETIME2(0) generating a
DATETIME2 column, with default precision, which is 7.
---
 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 37e798014..9e39ca9f2 100644
--- a/lib/sqlalchemy/dialects/mssql/base.py
+++ b/lib/sqlalchemy/dialects/mssql/base.py
@@ -773,7 +773,7 @@ class MSTypeCompiler(compiler.GenericTypeCompiler):
 
     def visit_DATETIME2(self, type_, **kw):
         precision = getattr(type_, 'precision', None)
-        if precision:
+        if precision is not None:
             return "DATETIME2(%s)" % precision
         else:
             return "DATETIME2"
-- 
cgit v1.2.1