title: Specify Date/Time Field Format through SQL in MS Access
body: <p>In MS Access, I am requiring to create automatically tables on demand (about 100 maybe more). </p>
  
  <p>SQL 'CREATE TABLE' command can handle this well, though I need to format a Date/Time Field, through an expression like this:</p>
  
  <pre><code>CREATE TABLE myTable (ID INTEGER, T DATETIME CONSTRAINT CT PRIMARY KEY, X DOUBLE, S CHAR)
  </code></pre>
  
  <p>The created table Field Properties look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/7RSjv.png" alt="Created Table"></p>
  
  <p>But i've not found a way to set the "Format" field property, to be "yyyy-mm-dd hh:nn:ss":</p>
  
  <p><img src="https://i.stack.imgur.com/87ii1.png" alt="Required Table"></p>
  
  <p>Is there a way to specify this, through an SQL Expression, not using MS Access Macros?</p>
  
  <p>Best wishes,</p>