title: DateTime format not match to expected format in SQL SERVER 2012
body: <p>After a hours of searching a solution to the problem i ask you for best answer : 
  i am building a project  in ASP.NET 2013 and i get a date from dateTimePicker (JQUERY script)
  i set it to format - dd/mm/yy and convert it to dateTime object in C# so the format in C# is : 
  <strong>dd/MM/yyyy HH:MM:SS</strong> and i send it to function insert it to SQL SERVER dataBse that expected to 
  <strong>MM/dd/yyyy HH:MM:SS</strong> format so the insert is faild and throw error   - </p>
  
  <p><strong>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</strong></p>
  
  <p>hope for quick solving the problem !</p>
  
  <p>Thanks,<br>
  shaul.</p>