title: SQL: how to specify a date format on creating a table and fill it
body: <p>I want to save the date in format 'dd.mm.yyyy'. So I read there are different formats for a date in SQL (by the way I use Visual Studio and SQL Server).</p>
  
  <p>I tried this code:</p>
  
  <pre><code>CREATE TABLE APP(
      ID   INT NOT NULL,
      DT DATE FORMAT 'dd.mm.yyyy',
      ADDRESS  NVARCHAR (100) ,
      PRIMARY KEY (ID)
  );
  </code></pre>
  
  <p>But it returns the error:</p>
  
  <blockquote>
    <p>Incorrect syntax near 'FORMAT'.</p>
  </blockquote>
  
  <p>After that I want to use this code:</p>
  
  <pre><code>INSERT INTO APP (ID, DT)
  VALUES ('1','22.12.2016')
  </code></pre>