title: best way to track time for create and update in SQL server
body: <p>i have a website that uses nhibernate to speak to SQL Server 2005.</p>
  
  <p>I now want every record to have a createdDateTime and lastUpdatedDateTime field.  Where should this value be set. i am worries about things like timezones, consistency, etc . .  any thoughts on the options below:</p>
  
  <ol>
  <li>Inside my application code (right before i do a write)</li>
  <li>Inside SQL Server (using triggers or other functions)</li>
  <li>Other ??</li>
  </ol>