A colleague reported this issue against our data access layer and we noticed that the milliseconds are missing in the SqlKata generated statement. We suspect
|
if (value is DateTime date) |
|
{ |
|
if (date.Date == date) |
|
{ |
|
return "'" + date.ToString("yyyy-MM-dd") + "'"; |
|
} |
|
|
|
return "'" + date.ToString("yyyy-MM-dd HH:mm:ss") + "'"; |
|
} |
these lines to be the cause of the issue. Is this intended behaviour?