title: How do you store DateTimeOffset in a SQL Server DateTime field
body: <p>This is in C#</p>
  
  <p>I'm consuming data from an RSS feed and want to store the data in our database. The problem that I'm having is how to store the LastUpdateTime.</p>
  
  <pre><code>XmlReader reader = XmlReader.Create(uri);
  SyndicationFeed rssFeed = SyndicationFeed.Load(reader);
  
  var lastUpdate = rssFeed.LastUpdatedTime;
  </code></pre>
  
  <p>The problem is that rssFeed.LastUpdateTime is a DateTimeOffset. However, we're using SQL Server 2005, which only has DateTime. What is the best practice for handling this scenario? If it matters, all our databases and servers are on Eastern time.</p>
  
  <p>Thanks.</p>