diff options
| author | Jacobo de Vera <devel@jacobodevera.com> | 2015-11-13 16:57:41 +0100 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-11-14 12:40:20 -0500 |
| commit | f34deb456e9d2a82fa8f2f1accc20a896760bd17 (patch) | |
| tree | abbb948e7725dceb658c8d48aba25da63df5f419 /lib/sqlalchemy | |
| parent | bc3ee40a2e20172acdf6dd98675342a356826ab9 (diff) | |
| download | sqlalchemy-f34deb456e9d2a82fa8f2f1accc20a896760bd17.tar.gz | |
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.
(cherry picked from commit 80ce23f6fd0f14ab656d3ec82773bd0cffbd4791)
Diffstat (limited to 'lib/sqlalchemy')
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/base.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index da8bbbd5f..3a81861bb 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -788,7 +788,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" |