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. --