title: Storing DateTime (UTC) vs. storing DateTimeOffset
body: <p>I usually have an "interceptor" that right before reading/writing from/to the database does DateTime conversion (from UTC to local time, and from local time to UTC), so I can use <code>DateTime.Now</code> (derivations and comparisions) throughout the system without worrying about time zones.</p>
  
  <p>Regarding serialization and moving data between computers, there is no need to bother, as the datetime is always UTC.</p>
  
  <p>Should I continue storing my dates (SQL 2008 - datetime) in UTC format or should I instead store it using <code>DateTimeOffset</code> (SQL 2008 - datetimeoffset)?</p>
  
  <p>UTC Dates in the database (datetime type) have been working and known for so long, why change it? What are the advantages?</p>
  
  <p>I have already looked into articles like <a href="http://blogs.msdn.com/b/bclteam/archive/2007/06/18/a-brief-history-of-datetime-anthony-moore.aspx" rel="noreferrer">this one</a>, but I'm not 100% convinced though.  Any thoughts?</p>