Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Best practice would be to always record log times as UTC:</p> <pre><code>DateTime now = DateTime.UtcNow; </code></pre> <p>This avoids several problems:</p> <ul> <li>Gaps when Daylight Saving Time starts</li> <li>Duplication / Ambiguity when Daylight Saving Time stops</li> <li>Log files from different machines not aligning due to time zone settings</li> </ul> <p>Additionally, if these are <em>servers</em> you are talking about, you should also set the time zone of the machine to UTC. That way, other logs on the system will also match up at the same times, even if they are set to record local values.</p> <p>Also, be aware that Windows wants the computer bios to be set to local time, while Linux wants it at UTC. This can cause some interesting behaviors, especially with virtual machines, if multiple VMs are running with different operating systems or if host and guest OS are different. Setting the local time zone to UTC avoids this.</p> <p>Regarding the strange output of <code>DateTime.ToString()</code> in Mono - are you by chance running on a Raspberry Pi? This is a known bug. See <a href="https://stackoverflow.com/a/15342062/634824">this answer</a> and the issue linked from there.</p> <p>I am not sure why you are getting UTC values instead of local values from Log4Net's <code>LoggingEvent.TimeStamp</code>, since <a href="http://logging.apache.org/log4net/release/sdk/log4net.Core.LoggingEvent.TimeStamp.html" rel="nofollow noreferrer">these docs</a> say it is local. However, it is possible you are using an appender that sends the UTC timestamp instead. In <a href="http://logging.apache.org/log4net/release/faq.html#distributed" rel="nofollow noreferrer">the FAQ</a>, there is a question that talks about UTC transmitted by a <code>RemotingAppender</code>. You might be doing something similar. I don't know for sure, since you didn't show that part of your code.</p>
    singulars
    1. This table or related slice is empty.
    1. PODateTime differences between Windows and Mono, and log4net remote appender
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMatt Johnson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODateTime differences between Windows and Mono, and log4net remote appender
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COYou're correct on all accounts! I am using `RemoteAppender`, which does indeed transmit UTC timestamps, but when I receive them, the `TimeStamp.Kind` is set to local. Perhaps a bug in log4net? Excellent answer, but doesn't directly address the UTC/Local issue. If no better answer comes along, you will definitely get the bounty. And now to install a soft-float on my RPi this weekend...
      singulars
      1. PO
      1. USSteve
    2. COPossibly they are handling the `Kind` wrong. But more likely just fallout from the bad design of `DateTime`. Have you read [these](http://noda-time.blogspot.com/2011/08/what-wrong-with-datetime-anyway.html) [articles](http://codeofmatt.com/2013/04/25/the-case-against-datetime-now/)?
      singulars
      1. PO
      1. USMatt Johnson
    3. COI'm starting to think this is due to the RPi hard-float, but can't confirm it since the version of Mono I can get for the soft-float Raspbian doesn't support other functionality in my software. You get the bounty, though, since the answer was filled with a ton of info. Thanks!
      singulars
      1. PO
      1. USSteve
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload