DateTimeOffset in Log4Net

Question

What is the value of log4net.Layout.PatternLayout to output the DateTimeOffset data type to the database?

This is what I have in the configuration file for log4net:

<log4net> .... <parameter> <parameterName value="@log_date" /> <dbType value="DateTime" /> <layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" /> </parameter> ... </log4net> 

And I want to have something like:

 <log4net> .... <parameter> <parameterName value="@log_date" /> <dbType value="DateTimeOffset" /> <layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff **OFFSET**}" /> </parameter> ... </log4net> 

Basically, we reuse the same database to register events from customers located in different time zones, so we want to know the exact local time of the event.

Thanks Alex

Answer 1

You must use any valid DateTime format string . Try the following:

 %date{yyyy-MM-ddTHH:mm:ss.fffzzz} 

Answer 2

Would define your DB column as DateTime and using %utcdate instead of %date help? This should make all timestamps compatible.