title: How to convert DateTime to a number with a precision greater than days in T-SQL?
body: <p>Both queries below translates to the same number</p>
  
  <pre><code>SELECT CONVERT(bigint,CONVERT(datetime,'2009-06-15 15:00:00'))
  SELECT CAST(CONVERT(datetime,'2009-06-15 23:01:00') as bigint)
  </code></pre>
  
  <p>Result</p>
  
  <pre><code>39978
  39978
  </code></pre>
  
  <p>The generated number will be different only if the days are different. There is any way to convert the DateTime to a more precise number, as we do in .NET with the .Ticks property?</p>
  
  <p>I need at least a minute precision.</p>