diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-11-14 11:39:58 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-11-14 11:39:58 -0500 |
| commit | ac9ded338fa85054f4277f0f92d7416ef26c53ed (patch) | |
| tree | be701731890c804e51574e077ad84a417e40920c | |
| parent | 37565d2ce2b4f0db5023c2549e2ddcb4a4ba0f7c (diff) | |
| parent | 80ce23f6fd0f14ab656d3ec82773bd0cffbd4791 (diff) | |
| download | sqlalchemy-ac9ded338fa85054f4277f0f92d7416ef26c53ed.tar.gz | |
Merge remote-tracking branch 'origin/pr/213' into pr213
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/base.py | 2 | ||||
| -rw-r--r-- | test/dialect/mssql/test_types.py | 2 |
2 files changed, 3 insertions, 1 deletions
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" diff --git a/test/dialect/mssql/test_types.py b/test/dialect/mssql/test_types.py index e782bd5e5..d8a82630b 100644 --- a/test/dialect/mssql/test_types.py +++ b/test/dialect/mssql/test_types.py @@ -464,6 +464,8 @@ class TypeRoundTripTest( (mssql.MSDateTime2, [], {}, 'DATETIME2', ['>=', (10,)]), + (mssql.MSDateTime2, [0], {}, + 'DATETIME2(0)', ['>=', (10,)]), (mssql.MSDateTime2, [1], {}, 'DATETIME2(1)', ['>=', (10,)]), |