Hello,
DAL with MSSQL
Query like:
db(db.mytable.date>now()).select()
Gives error:
<class 'pyodbc.DataError'> ('22007', '[22007] [FreeTDS][SQL
Server]Conversion failed when converting character string to smalldatetime
data type. (295) (SQLExecDirectW)')
now() -> translated into:
'2012-09-19 23:22:56.977817')
Running select using '2012-09-19 23:22:56.977817' from MS SQL Studio gives
same error,
BUT
if I use shorter time:
'2012-09-19 23:22:56.977') - this works.
Please let me know how to workaround this?
Search gave nothing useful.
--
