title: Ticks in sql for 01/01/1901 00:00:00
body: <p>I am try to use a redgate product that needs the date in ticks i.e 634925952000000000 = 01/01/2013 00:00:00   </p>
  
  <p>Can I find a convertor to work out 01/01/1901 00:00:00 in sql</p>
  
  <p>without this happening "The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart."</p>
  
  <pre><code> SELECT DATEDIFF(s, '19010101', GETDATE())*1000000
  </code></pre>
  
  <p>answer no can anyone help.</p>
  
  <p>Just the the value for 01/01/1901 00:00:00 really as app use this as a null date.</p>