What version of MS SQL Server are you using? This behavior sounds quite different from that described by the datetime documentation. It doesn't look like SET DATEFORMAT could cause this either. This ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target.