Generated SQL for `datetime` filter is using `datetime2` format, resulting in SqlException · Issue #13133 · dotnet/efcore · GitHub
KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL transformations in MicroStrategy SQL Generation Engine
![i can not understand why a query filtering on datetime field is not working on sql server 2016 - Stack Overflow i can not understand why a query filtering on datetime field is not working on sql server 2016 - Stack Overflow](https://i.stack.imgur.com/FXmVA.png)