title: Storing date as BigInt on sql server - is this a good idea?
body: <p>Okay now let me give an example</p>
  
  <p>date : <code>15.12.2012 00:16:39</code></p>
  
  <p>Now this will be stored as</p>
  
  <pre><code>20121215001639
  </code></pre>
  
  <p>Now for example if i want to retrieve rows older than 30 min (30*60=1800 sec)</p>
  
  <p>I can do just as</p>
  
  <pre><code>where date&lt;20121215001639+1800 
  </code></pre>
  
  <p>So would this be a performance way instead of storing as date time ?</p>