[Sqlalchemy-tickets] [sqlalchemy] #1254: MSsql smalldattime truncates to only date
Brought to you by:
zzzeek
From: sqlalchemy <mi...@zz...> - 2008-12-18 16:51:16
|
#1254: MSsql smalldattime truncates to only date --------------------+------------------------------------------------------- Reporter: guest | Owner: ram Type: defect | Status: new Priority: medium | Milestone: Component: mssql | Severity: no triage selected yet Keywords: | Status_field: awaiting triage --------------------+------------------------------------------------------- I found that when using pyodbc, MS SQLserver smalldatetime columns were always returned as a datetime object with only the date components set, and the time missing. I've attached a one-liner patch to make the MSSQLDialect use MSDateTime_pyodbc instead of MSDate_pyodbc for smalldatetime columns. -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1254> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |