title: Convert SQL Server DateTime object to BIGINT (.Net ticks)
body: <p>I need to convert a DateTime type value to BIGINT type in .Net ticks format (number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001).</p>
  
  <p>The conversion should be perform in Sql server 2008 using T-SQL query</p>
  
  <p>For example:</p>
  
  <pre><code>DateTime value - 12/09/2011 00:00:00
  </code></pre>
  
  <p>will convert to:</p>
  
  <pre><code>BIGINT value - 634513824000000000
  </code></pre>