title: How to insert datetime like this format 'MM/dd/yyyy hh:mm:ss'?
body: <p>I want to insert my DateTime into SQL Server like 'MM/dd/yyyy hh:mm:ss'.</p>
  
  <p>Generally, I have formed the below query to insert that DateTime in SQL.</p>
  
  <pre><code>insert into tablename values(convert(date,'10/02/2012',110))
  </code></pre>
  
  <p>It inserts like this <code>"2012-10-02"</code> but I don't know why it inserts like this?</p>
  
  <p>I am new to SQL Server.</p>
  
  <p>Is this possible way to store like this <strong><code>'02-10-2016'</code></strong> in US format?</p>