Set up date format during creating table
<p>I create column as below:</p>

<pre><code>ReportingPeriod DATETIME
</code></pre>

<p>Now I noticed that it has format:</p>

<pre><code>yyyy-mm-dd hh:mm:ss[.fff]    
2016-03-11 00:00:00.000
</code></pre>

<p>It's possible to <strong>set up format as "DD/MM/YYYY" during creating table?</strong>
something as:</p>

<pre><code>ReportingPeriod DATETIME format("DD/MM/YYYY")
</code></pre>