The operations.py includes some code that causes issues with SQL Server 2008

WilliamRen / django-pyodbc

Automatically exported from code.google.com/p/django-pyodbc

BSD 3-Clause "New" or "Revised" License

0 stars 0 forks source link

The operations.py includes some code that causes issues with SQL Server 2008 #116

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

Basically the issue is that v2005 does not support microseconds where 2008 
does. This causes issues trying to match dates exactly since a Python datetime 
value might be queried (and its microsecond will be stripped) and then used as 
an exact filter in return will return no values.

I'll be happy to explain further if that is not clear.

Original issue reported on code.google.com by jacques....@gmail.com on 6 Oct 2011 at 8:42

GoogleCodeExporter commented 8 years ago

We're running into this as well. Is it practical to round the microsecs to 
millisecs by way of a CAST() operation in the driver (operations.py perhaps)?

Original comment by klum...@gmail.com on 24 Oct 2011 at 5:32