title: Date format in SQL Server
body: <p>Short Question:</p>
  
  <p>What's the best date format to use in SQL Server?</p>
  
  <p>Long Explanation:</p>
  
  <p>We're converting our database from mysql to SQL Server.  In mysql we always used <code>int(11)</code> to avoid the daylight savings time issue, should we be doing the same in mysql (or is <code>DATETIME</code> good enough)?</p>
  
  <p>The use of the dates vary.  Most of the time they're just informative about when various things occurred (for logging purposes).  Sometimes they are used to order work to be done.</p>
  
  <p>We're using 2005 (sigh), but I'd love to hear about 2008 as well.</p>