title: Error "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." while store date formate is dd-mm-yyyy
body: <p>How to resolve this error in SQL Server:</p>
  
  <blockquote>
    <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value</p>
  </blockquote>
  
  <p>My query is: </p>
  
  <pre><code>Insert into Pedido (FechaPedido, FechaTipoPedido) 
  Values('13-03-2018', '13-03-2018')
  </code></pre>