Hi
There is and issue when SQL datatype i Date where the SqlDataReader is returning a DateTime .Net datatype and thus the json result will be of the format "2026-03-11T00:00:00". The expected result from SQL query would be 2026-03-11. I suspect the same would apply for SQL Time datatype.
This causes for unnecessary processing of the result.
The task needs to handle this and add explicit use of .Net DateOnly (and TimeOnly) to get the correct value in case SQL datatype is Date (or Time).
Hi
There is and issue when SQL datatype i Date where the SqlDataReader is returning a DateTime .Net datatype and thus the json result will be of the format "2026-03-11T00:00:00". The expected result from SQL query would be 2026-03-11. I suspect the same would apply for SQL Time datatype.
This causes for unnecessary processing of the result.
The task needs to handle this and add explicit use of .Net DateOnly (and TimeOnly) to get the correct value in case SQL datatype is Date (or Time).