We have IBM i v 7.1
In previous version there was support for canonical functions and there was DB2 driver specific db functions too available.
If I have a table that has date column, how do I compare it in LINQ correctly in dotnet core 2.1 + IBM. EntityFrameworkCore 126.96.36.199 ?
var dateToBeCompared = new DateTime(2018,1,1).Date;
var result = _dbContext.SomeTable.Where(t => t.SomeFieldAsDate > dateToBeCompared).ToList();
It executes the query against Db2 in IBM i, but job log has diagnostic message:
"SQL0181 - Value in date, time, or timestamp string not valid"
Above message comes from the fact that after linq is resolved there is string with both date and time.
Can you give me example how to resolve this correctly that our job logs are not full of these diagnostic messages ?