If Timestamp column is set to UTC, Timestamp property in LogEvent column should be UTC too #659
Description
I have the following configuration with Serilog.Sinks.MSSqlServer v9.0.02:
"Serilog": { "Using": [ "Serilog.Sinks.MSSqlServer" ], "MinimumLevel": { "Default": "Information" }, "WriteTo": [ { "Name": "MSSqlServer", "Args": { "connectionString": "LogsConnection", "sinkOptionsSection": { "tableName": "Logs", "autoCreateSqlTable": true }, "restrictedToMinimumLevel": "Information", "columnOptionsSection": { "addStandardColumns": [ "LogEvent" ], "removeStandardColumns": [ "MessageTemplate", "Properties" ], "timeStamp": { "columnName": "Timestamp", "convertToUtc": true, }, "logEvent": { "excludeAdditionalProperties": false, "excludeStandardColumns": false } } } } ], "Enrich": [ "FromLogContext" ] }In particular, I have set the convertToUtc property of timeStamp column to true. With this configuration, I expect that also the Timestamp property in the JSON LogEvent column will be saved as UTC. However, I see values like this:
{ "Timestamp":"2025-12-12T08:30:25.4094643", "Level":"Information", "Message":"Request finished \"HTTP/2\" \"GET\" \"https\"://\"localhost:7164\"\"\"\"/api/ping\"\"\" - 200 0 null 39.3178ms", // ... }Where Timestamp property is missing the Z modifier.