Datetime field error while querying mssql db

[rajat091]

After managing to install and run caravel on windows (which required lots of debugging), I am facing one hurdle that I am not able to cross.

I would define myself as more of a business user and less technically nuanced. So I am not sure if this issue has a trivial solution.

When querying my mssql db, I am getting the following error:-
Conversion failed when converting date and/or time from character string

I know this can be resolved if I dont add (or add fewer) decimal places to my datetime field in the where clause of the query.

I just dont know how to ask caravel to do that. It is just plain weird that when sql server supports only 3 decimal places to the seconds field, why is this app adding more than that.

I have tried to read the sqlalchemy doc but to no avail. Being somewhat technically handicapped, it has taken tremendous effort to get this running on windows and it sucks to be stuck now!

[rajat091]

Removed decimal in tf in models.py. that solved it for me now.