title: Conversion of a varchar data type to a datetime data type resulted in an out-of-range value
body: <p>I am trying to insert the date into a data table using a datetimepicker, this particular column's data as been specified as datetime.</p>
  
  <p>Whenever I run my project I get this error:</p>
  
  <blockquote>
    <p>Conversion of a varchar data type to a datetime data type resulted in an out-of-range value</p>
  </blockquote>
  
  <p>Here is my sql command:</p>
  
  <pre><code>'" + Convert.ToDateTime(MyDateTimePicker.Text) + "'
  </code></pre>