Thanks Michael, you're correct I'm using pyodbc with FreeTDS, which doesn't
recognize the time datatype (and it seems FreeTDS doesn't support anything
above SQLServer 2005). And you're right, this is not a SQLAlchemy issue.
Sorry about that. I guess I can work around this by using time.isoformat
On Oct 31, 2011, at 1:18 AM, Simon Haines wrote:
> I think I've found a bug--can anyone else confirm this? It appears that
> SQLAlchemy cannot query SQLServer time columns because Python datetime.time
> objects are always promoted to full datetime types. Once promoted the
> SQLServer returns t