title: Why DATEDIFF in SQL Server returning error while interval is set to second
body: <p>While running following query</p>
  
  <pre><code>select DATEDIFF(SECOND, 0, DATEADD(SECOND, -1, '2014-04-11 23:52'))
  </code></pre>
  
  <p>I am getting following error message, no matter whatever the date I provide to it.</p>
  
  <blockquote>
    <p>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>
  </blockquote>