Re: [sqlalchemy] Querying mssql time columns

2011-10-31 Thread Simon Haines
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

[sqlalchemy] Querying mssql time columns

2011-10-30 Thread Simon Haines
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 the error: 'The data types time and datetime are

Re: [sqlalchemy] Querying mssql time columns

2011-10-30 Thread Michael Bayer
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 the