title: SQL Server: the conversion of a varchar data type to a datetime data type resulted in an out-of-range value
body: <p>I want to insert the date and time in two ways which is shown as below:</p>
  
  <p>Table: ft</p>
  
  <pre><code>create table ft
  (
     columndate datetime,
     columntime datetime
  )
  </code></pre>
  
  <p>Insertion of records: format 1</p>
  
  <pre><code>insert into ft values('2014-12-25', '01:55:56');
  </code></pre>
  
  <p>Insertion of records: format 2</p>
  
  <pre><code>insert into ft values('25-12-2014', '01:45:54');
  </code></pre>
  
  <p><strong>Note</strong>: Yeah! Of course I want to insert only date for first column that is <code>columndate</code> and time for second column that is <code>columntime</code> and I want to use <code>datetime</code> datatype for that. For both the format of insertion I am getting the same error which is shown as below:</p>
  
  <p>Error:</p>
  
  <blockquote>
    <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>